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 |
|
ballabhoks
Starting Member
18 Posts |
 Posted - 2003-12-08 : 09:33:39
|
| Dear All, I am facing a problem "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." during import/export or during inserting data into a table. Though I have increased the Locks by 50000, but still the same problem is coming.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-08 : 12:19:37
|
| You need to add more RAM in order to maintain more locks on your system.Tara |
 |
|
|
|
|
|
SQL Server Run out of Locks