Marks a merge subscription for reinitialization the next time the Merge Agent runs.
sp_reinitmergesubscription [[@publication =] 'publication'
[,[@subscriber =] 'subscriber', [@subscriber_db =] 'subscriber_db'
0 (success) or 1 (failure)
sp_reinitmergesubscription is used in merge replication.
sp_reinitmergesubscription can be called from the Publisher to reinitialize merge subscriptions. It is advisable to rerun the Snapshot Agent as well.
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_reinitmergesubscription.
System Stored Procedures |