| title | sp_vupgrade_replication (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology |
|
||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | d2c0ed66-07d1-4adc-82e5-a654376879bc | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Activated by setup when upgrading a replication server. Upgrades schema and system data as needed to support replication at the current product level. Creates new replication system objects in system and user databases. This stored procedure is executed at the machine where the replication upgrade is to occur.
Transact-SQL Syntax Conventions
sp_vupgrade_replication [ [@login=] 'login' ]
[ , [ @password= ] 'password' ]
[ , [ @ver_old= ] 'old_version' ]
[ , [ @force_remove= ] 'force_removal' ]
[ , [ @security_mode= ] security_mode ]
[ @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.
Note
This parameter is ignored when you are upgrading to [!INCLUDEssVersion2005] and later versions.
[ @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.
Note
This parameter is ignored when you are upgrading to SQL [!INCLUDEssVersion2005] and later versions.
[ @ver_old=] 'old_version'
[!INCLUDEssInternalOnly]
This stored procedure is deprecated and will be removed in a future release of [!INCLUDEssNoVersion].
[ @force_remove=] 'force_removal'
[!INCLUDEssInternalOnly]
[ @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 0. If 0, [!INCLUDEssNoVersion] Authentication will be used. If 1, Windows Authentication will be used.
Note
This parameter is ignored when you are upgrading to [!INCLUDEssVersion2005] and later versions.
0 (success) or 1 (failure)
sp_vupgrade_replication is used when upgrading all types of replication.
Only members of the sysadmin fixed server role can execute sp_vupgrade_replication.
Replication Stored Procedures (Transact-SQL)
Validate Replicated Data