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!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |