Hi

I 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.