Good morning,
I have a sql server 2000 machine, with SP4.
I have a transactional replication.
A keep receving this error message:
The process could not execute 'sp_replcmds' on 'servername'
the logreader stops responding.When i click start it starts fine, and the replication starts fine.And then, works for hours, and the problem comes back.
In the begining i though it could be timeouts, but i already set a couple of parameters in the logreader profile,like querytimeout/readbatchsize.
Sometimes when the logreader stops,it generates a dump, but not always.
In event viewer, it appears this message:
17066 :
SQL Server Assertion: File: , line=1985
Failed Assertion = 'startLSN = m_curLSN'.
18052 :
Error: 3624, Severity: 20, State: 1.
17066 :
SQL Server Assertion: File: , line=2223
Failed Assertion = 'm_noOfScAlloc == 0'.
I also executed checkdb in the databases, and they are fine.
have you every experienced something similar?
thanks in advance,
Renato Alves.