sql server replication:
Hi,

I use SQL Server 2000 SP3 and using Transaction Replication, My replication
running well, but yesterday/suddenly I found error at Log Reader Agent
History :
"The process could not execute 'sp_replcmds'on 'XLINK-SQL' "

is there any store procedure should I fix ?
can any one help me with my problem?


Regards,

Hendra Wijaya

Did you do a large update or insert into a published table at that time?

If you look up Agent history, you will see more information about the error
message. If it is a timeout, then it is not serious...you could simply
restart the agent. If needed, you could increase the timeout values for
logreader. See "Replication Log Reader Agent Utility" in SQL Server Books
Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


[quoted text, click to view]

Hi,

I use SQL Server 2000 SP3 and using Transaction Replication, My replication
running well, but yesterday/suddenly I found error at Log Reader Agent
History :
"The process could not execute 'sp_replcmds'on 'XLINK-SQL' "

is there any store procedure should I fix ?
can any one help me with my problem?


Regards,

Hendra Wijaya