Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_reinitmergesubscription
Collapse the table of content
Expand the table of content

sp_reinitmergesubscription

SQL Server 2000

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

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_reinitmergesubscription.

See Also

System Stored Procedures

Show:
© 2015 Microsoft