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.
| Author |
Topic |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2001-06-18 : 23:44:28
|
| Has anyone seen this:SQL Server has run out of LOCKS. Rerun your statement when there are fewer active users, or ask the system administrator to reconfigure SQL Server with more LOCKS.Ok, that was the easy question. Question 2, how do I work around this? I understood that if locks were set to 0, sql would handle all the locking itself and allocate as needed. So we've been set at 0 forever. This just started happening today. I then changed locks, using sp_configure 'locks',900000 which is plenty and I still get the message. This will happen for a large insert, or a truncate table statement, so I know it's not the log. I'm stuck!Mike F |
|
|
|
|
|
Late Night Fun In SQL Town