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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-03-12 : 10:25:46
|
| Hi,How do I increase the number of lock for the server via Enterprise Manager? instead of excute the sp_configureThanks |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-03-12 : 10:37:41
|
| I speak under correction, but I don't think you can do this from Enterprise manager. I assume you're on SQL 7 or 2K ?Why would you need to, or is it a FYIciao |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-12 : 11:22:45
|
| Yeah, you're right, it has to be done using sp_configure:EXECUTE sp_configure 'locks', '15000'RECONFIGURE WITH OVERRIDEThis will set the maximum locks to 15,000. |
|
|
|
|
|
|
Lock