Sp_MSpub_adjust_identity
May 4, 2007Twice 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:
Message
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.