Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Out of Locks

Author  Topic 

mfemenel
Professor Frink

1421 Posts

Posted - 2001-05-01 : 09:13:52
I have a sql database that runs some DTS jobs to import data into our server. The only thing running on this server is DTS, no other users connect to this database. I'm receiving an error:
"SQL Server has run out of locks" and then it goes on to say that you should reconfigure SQL to allow more locks.
1. What the hell is this?! 2. How does one reconfigure SQL to allow more locks. BOL is sketchy so far on this topic. I'm running SQL7 SP2

Mike F


Edited by - mfemenel on 05/01/2001 09:16:49
   

- Advertisement -