var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: could not execute sp_replcmds (SQL Svr 7)
We've just set up transactional replication on our Fault Call Logging system (HEAT). It runs on SQL Server 7 Ent Edition SP3.
After 3 days of no issues we've been hit by the following error:
The process could not execute 'sp_replcmds' on 'CORPDATA'.
Replication failure. File 'R:\SPHINX\NTDBMS\srvrepl\src\replicat.cpp', line 3207.
I've looked on google and the only thing that comes up is for SQL Server 2000, not 7.
Has anyone seen this in SQL Svr 7? And if so, how did you resolve it.
I've increased the QueryTimeout, set BatchSize to 1 (and also increased it), and output the log reader to an output file, but this gives no more than the onscreen error details.