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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2005-05-04 : 14:55:02
|
| We seem to be having this issue. Don't really understand what is happening and how to resolve. Will a simple restarting SQLSERVER service fix the problem?The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 15:19:37
|
| You need more RAM added to your system.Tara |
 |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2005-05-04 : 15:22:28
|
| Would I need more ram added to my desktop or to the server? I am thinking Server? Right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 15:24:40
|
| Yes the server.Tara |
|
|
|
|
|
|
Locking