Could not find stored procedure ‘dbo.sp_MSins_dboTest’

Transaction Replication is failing due to the above error and this error can be shown in the Replication monitor.

If you run the following query in your publication database, you will see the following results.

SELECT name,

         del_cmd,

         ins_cmd,

         upd_cmd

         FROM dbo.sysarticles

This means that the above listed stored procedures   are not available for some reason.(perhaps the old backup is set to subscriber without generating from the snapshot).

You can generate these stored procedures by executing following system stored procedure.

Exec sp_scriptpublicationcustomprocs  ‘Publishername’

This will generate the relevant stored procedures for the publisher and you will need to apply them to the subscriber or publisher database depending on the subscription type.




Array

No comments yet... Be the first to leave a reply!