Skip to content

sp-vupgrade-mergeobjects-transact-sql.md

Latest commit

 

History

History
64 lines (47 loc) · 3.21 KB

sp-vupgrade-mergeobjects-transact-sql.md

File metadata and controls

64 lines (47 loc) · 3.21 KB
title sp_vupgrade_mergeobjects (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology replication
ms.topic language-reference
f1_keywords
sp_vupgrade_mergeobjects
sp_vupgrade_mergeobjects_TSQL
helpviewer_keywords
sp_vupgrade_mergeobjects
ms.assetid 73257c2e-cc4c-48e7-9d66-7ef045bdd4f5
author stevestein
ms.author sstein

sp_vupgrade_mergeobjects (Transact-SQL)

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

Regenerates the article-specific triggers, stored procedures, and views that are used to track and apply data changes for merge replication. Execute this procedure in the following situations:

  • If an object required by replication is accidentally dropped.

  • If you apply an update, such as a hotfix, that requires modification to one or more replication objects. Execute the procedure on each node after applying the update.

Executing this stored procedure does not require reinitialization of subscriptions. This procedure is not required if you install a service pack or upgrade to a new version of [!INCLUDEssNoVersion].

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_vupgrade_mergeobjects [ [@login = ] 'login' ]  
    [ , [ @password = ] 'password' ]  
    [ , [ @security_mode = ] security_mode ]

Arguments

[ @login = ] 'login' Is the system administrator login to use when creating new system objects in the distribution database. login is sysname, with a default of NULL. This parameter is not required if security_mode is set to 1, which is Windows Authentication.

[ @password = ] 'password' Is the system administrator password to use when creating new system objects in the distribution database. password is sysname, with a default of '' (empty string). This parameter is not required if security_mode is set to 1, which is Windows Authentication.

[ @security_mode = ] 'security_mode' Is the login security mode to use when creating new system objects in the distribution database. security_mode is bit with a default value of 1. If 0, [!INCLUDEssNoVersion] Authentication will be used. If 1, Windows Authentication will be used. [!INCLUDEssNoteWinAuthentication]

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_vupgrade_mergeobjects is used only for merge replication.

Permissions

Requires membership in the sysadmin fixed server role.

See Also

Replication Stored Procedures (Transact-SQL)
Upgrade Replicated Databases