Running out of resources??? 
Author Message
 Running out of resources???

I have a query that uses several cursors and an insert statement to create
unique dummy data in a single table.  The query quits processing after
~2325 inserts.  Further, I cannot run any other insert queries until
Enterprise Manager is exited and re-started.  I have tried to use
Performance Monitor to see what resource I am running out of, but I have
not found anything.  Also, I have checked both the T-Log and DB after the
query halts, and both have plenty of space.  I would appreciate any
suggestions.



Fri, 05 Nov 1999 03:00:00 GMT
 Running out of resources???

Check the Event Log -- it sounds like you might be running out of
locks.

Randy Brokaw
Data National Corp

Quote:

>I have a query that uses several cursors and an insert statement to create
>unique dummy data in a single table.  The query quits processing after
>~2325 inserts.  Further, I cannot run any other insert queries until
>Enterprise Manager is exited and re-started.  I have tried to use
>Performance Monitor to see what resource I am running out of, but I have
>not found anything.  Also, I have checked both the T-Log and DB after the
>query halts, and both have plenty of space.  I would appreciate any
>suggestions.



Wed, 15 Dec 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Time Outs When running a query

2. Running DTS:- ERROR "System Resource Exceededï¿¡

3. How free resources after run jobs???

4. vb application running as clustered resource

5. Running out of resources

6. Running out of Resources???

7. Limiting Resources while running SPs

8. Freeing up PC Resources When Running a Querydef

9. Running out of resources

10. Resources required to compile and run SHORE object manager

11. FPW26 and Win95 running out of resources

12. MS SQL Server 2000 time-outs periodicly over the internet


 
Powered by phpBB® Forum Software