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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2007-09-19 : 09:18:21
|
| HiI have setup replication on a production database and the logreader is giving following error....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.(Source: SERVER1 (Data source); Error number: 1007)----------------------------------------------------------------------IDistPut Interface has been shut down.(Source: (Agent); Error number: 2000)----------------------------------------------------------------------I have set MS-SQL Server to allocate locks dynamically using sp_configure and the locks value is 0.What is causing this error and how to fix it. Please help.Raj. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-19 : 23:43:56
|
| Does server have enough memory to allocate new locks? |
 |
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-09-20 : 07:02:22
|
| HiHow can we allocate more memory in the server for locks?is there a way, can we configure?Raj. |
|
|
|
|
|
|
Replication logreader error.