"Synchronous replication common error handling 3" Cannot find stored procedures Sp_msins_tablename

Environment error in SQL2008 R2 synchronous replication

This error message is due to a synchronous stored procedure that is called when synchronization is not found on the Subscriber, MS Error Description:

When a transaction is published in SQL Server Auto-sync settings Select Subscribers to insert, update, and delete stores in each table that are included in the Subscriber creation process for that publication. If you manually synchronize subscriptions to these stored procedures will not be created, and must be created manually. because in this case (manual synchronization) A stored procedure that does not exist at the Subscriber, the distribution job generates the following error message through subsequent inserts: Unable to find stored procedure Sp_msins_tablename

The error picture is as follows:

The same DB object has the object OK, some can generate synchronous storage over Kamimachi, interface, the following settings are not effective:

Processing method:

1. Execute the following script in the release-release data

Use [Publish Database]goexec sp_scriptpublicationcustomprocs ' release name '

--View objects that do not have synchronized storage

Use Dbnamegoselect DISTINCT object_name (id) from sys.sysdepends WHERE depid=object_id (' table name ') and object_name (id) like ' sp[ _]%‘

2. Generate synchronous stored procedure script, find no synchronous storage replication generated, execute at Subscriber.

Microsoft Official Website Introduction: Click Open Link

"Synchronous replication common error handling 3" Cannot find stored procedures Sp_msins_tablename