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

  • 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.

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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply