sp_vupgrade_replication

Transact-SQL Reference

Transact-SQL Reference

sp_vupgrade_replication

Activated by setup when upgrading a replication server from SQL Server 7.0 or later. 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.

Syntax

sp_vupgrade_replication [ [@login =] 'login' ]
    [ , [ @password = ] 'password' ]
    [ , [ @ver_old = ] 'old_version' ]
    [ , [ @force_remove = ] 'force_removal' ]
    [ , [ @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 SA. This parameter is not required if security_mode is set to 1, which is NT 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 NT Authentication.

[@ver_old = ] 'old_version'

For internal use only.

[@force_remove = ] 'force_removal'

For internal use only.

[@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, SQL Server Authentication will be used. If 1, NT Authentication will be used.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_vupgrade_replication is not used when upgrading from SQL Server 6.5.

Permissions

Only members of the sysadmin fixed server role can execute sp_vupgrade_replication.

See Also

Overview of Installing SQL Server 2000

Replication Overview

System Stored Procedures

Help with Replication

Upgrading from SQL Server 7.0 to SQL Server 2000

Validating Replicated Data

Validate Subscriber Information