Transaction Replication:Distributn Agent Error Could Not find stored procedure 'sp_MSdel

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Transaction Replication:Distributn Agent...

Transaction Replication:Distributn Agent Error Could Not find stored procedure 'sp_MSdel_co'

Rate Topic

Display Mode

Topic Options

Author

Message

cchyne

Posted Thursday, March 19, 2009 4:56 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 08, 2009 4:10 PM
Points: 2, Visits: 9

I'm new to replication.I have just setup Transaction replication.I restored the publisher DB to the subscriber server to avoid initial snapshot processing.Now after runing thru everything, i updated a row in one of the publication tables but it does not reflect in the subsriber DB.Distribution agent error says: Could not find stored procedure 'sp_MSdel_co'.How do i resolve this?Please i need help since i should be deploying this to a production environment.Thanks.

Post #680021

ab5sr

Posted Thursday, March 19, 2009 7:30 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:27 PM
Points: 214, Visits: 613

You know, there will probably be a better response, but I had this once and just went and created the proc for SQL Server.

Lee Everest

Post #680074

cchyne

Posted Thursday, March 19, 2009 8:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 08, 2009 4:10 PM
Points: 2, Visits: 9

Thanks for the response Lee.Till the better reply shows up, could you please give me a detailed breakdown of your solution?Thank u very much.

Post #680096

« Prev Topic | Next Topic »

Permissions