Twice in 2 days I haveÃÂ had a log_reader agent fail because of this proc.ÃÂ The error is "The process could not execute 'sp_MSpub_adjust_identity' on <Publisher Server Name>".
The publisher isÃÂ SQL2000 SP4.
The distributor is SQL 2005 SP2 x64.
The subscriber is the same instance as the distributor, SQL 2005 SP4 x64.
Transactional Replication has been setup for more than a month with no problems, then this weekÃÂ 2 different log reader agents failed with the same error.ÃÂ I restarted the log readers and everything has been fine, so far. ÃÂ I have found very little useful information about this stored proc and nothing about why it would fail.
The full error message is:
2007-05-04 00:48:34.928 Status: 0, code: 20011, text: 'The process could not execute 'sp_MSpub_adjust_identity' on '<Publisher Server Name>.'.
2007-05-04 00:48:34.928 The process could not execute 'sp_MSpub_adjust_identity' on '<Publisher Server Name>'.
2007-05-04 00:48:34.928 Status: 0, code: 7399, text: 'OLE DB provider 'SQLOLEDB' reported an error.ÃÂ '.
Any help would be appreciated.
View Complete Post