.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links


Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

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

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend