sp-reinitmergesubscription-transact-sql.md

title	sp_reinitmergesubscription (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/04/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	sp_reinitmergesubscription_TSQL sp_reinitmergesubscription
helpviewer_keywords	sp_reinitmergesubscription
ms.assetid	249a4048-e885-48e0-a92a-6577f59de751
author	stevestein
ms.author	sstein

sp_reinitmergesubscription (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

Transact-SQL Syntax Conventions

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 whether changes at the Subscriber are uploaded before the subscription is reinitialized. 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. We recommend re-running the Snapshot Agent as well.

If you add, drop, or change a parameterized filter, pending changes at the Subscriber cannot be uploaded to the Publisher during reinitialization. If you want to upload pending changes, synchronize all subscriptions before changing the filter.

Example

[!code-sqlHowTo#sp_reinitmergepushsub]

Example

[!code-sqlHowTo#sp_reinitmergepushsubwithupload]

Permissions

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

See Also

Reinitialize Subscriptions
System Stored Procedures (Transact-SQL)