Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transaction Replication:Distributn Agent Error Could Not find stored procedure 'sp_MSdel_co' Expand / Collapse
Author
Message
Posted Thursday, March 19, 2009 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, March 19, 2009 7:30 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 21, 2014 8:18 AM
Points: 214, Visits: 642
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
Posted Thursday, March 19, 2009 8:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse