sp_replsync Replication Stored Procedure

Used from a subscription server to acknowledge completion of a manual synchronization.

Syntax

sp_replsync publisher, publisher_db, publication [, article]

where

publisher

Is the name of the publisher.

publisher_db

Is the name of the database used.

publication

Is the name of the publication.

article

Is the name of the article.

Remarks

This stored procedure informs the distribution server that manual synchronization is complete. If all three of these fields are matched in the MSlast_job_info table, sp_replsync increments job_id by 1. (These fields are populated in MSlast_job_info when the distribution process encounters the job containing this specific manual synchronization event.) If no article is specified, all articles in the publication are marked as synchronized.

Example

This example, used from a subscription server, acknowledges the completion of manual synchronization for the WOLFHOUND server's mydb database, containing the mypub1 publication with the article myart3.

sp_replsync WOLFHOUND, mydb, mypub1, myart3

Permission

Execute permission defaults to the system administrator and the database owner.

Tables Used

sysobjects, MSlast_job_info

See Also