Transact-SQL Reference

sp_reinitmergesubscription

Marks a merge subscription for reinitialization the next time the Merge Agent runs. This stored procedure is executed at the Publisher in the publication database.

Syntax

sp_reinitmergesubscription [ [ @publication = ] 'publication'
    [ , [ @subscriber = ] 'subscriber'
    [ , [ @subscriber_db = ] 'subscriber_db'
    [ , [ @upload_first = ] 'upload_first'

Arguments

[@publication =] 'publication'

Is the name of the publication. publication is sysname, with a default of all.

[@subscriber =] 'subscriber'

Is the name of the Subscriber. subscriber is sysname, with a default of all.

[@subscriber_db =] 'subscriber_db'

Is the name of the Subscriber database. subscriber_db is sysname, with a default of all.

[@upload_first =] 'upload_first'

Is the name of the Subscriber database. upload_first is nvarchar(5), with a default of FALSE. If true, changes are uploaded before the subscription is reinitialized. If false, changes are not uploaded.

Return Code Values

0 (success) or 1 (failure)

Remarks

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.

Permissions