Skip to content

Latest commit

 

History

History
72 lines (49 loc) · 3.09 KB

sp-vupgrade-mergeobjects-transact-sql.md

File metadata and controls

72 lines (49 loc) · 3.09 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_vupgrade_mergeobjects (Transact-SQL)
Regenerates the article-specific triggers, stored procedures, and views that are used to track and apply data changes for merge replication.
markingmyname
maghan
randolphwest
11/02/2023
sql
replication
reference
sp_vupgrade_mergeobjects
sp_vupgrade_mergeobjects_TSQL
sp_vupgrade_mergeobjects
TSQL

sp_vupgrade_mergeobjects (Transact-SQL)

[!INCLUDE SQL Server]

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, which requires modification to one or more replication objects. Execute the procedure on each node after applying the update.

Executing this stored procedure doesn't require reinitialization of subscriptions. This procedure isn't required if you install a service pack or upgrade to a new version of [!INCLUDE ssNoVersion].

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

Arguments

[ @login = ] N'login'

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 isn't required if @security_mode is set to 1, which is Windows Authentication.

[ @password = ] N'password'

The system administrator password to use when creating new system objects in the distribution database. @password is sysname, with a default of an empty string. This parameter isn't required if @security_mode is set to 1, which is Windows Authentication.

[ @security_mode = ] security_mode

The login security mode to use when creating new system objects in the distribution database. @security_mode is bit, with a default of 1. If 0, [!INCLUDE ssNoVersion] Authentication is used. If 1, Windows Authentication is used. [!INCLUDE ssNoteWinAuthentication]

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, or execute permission directly on this stored procedure.

Related content