Changes the password for a Distributor. This stored procedure is executed at the Distributor on any database.
sp_changedistributor_password [ @password= ] 'password'
[ @password = ] 'password'
Is the new password. password is sysname, with no default. If the Distributor is local, the password of the distributor_admin system login is changed.
Return Code Values
0 (success) or 1 (failure)
sp_changedistributor_password is used in all types of replication.
-- Change the password on the Distributor. -- To avoid storing the password in the script file, the value is passed -- into SQLCMD as a scripting variable. For information about how to use -- scripting variables on the command line and in SQL Server Management -- Studio, see the "Executing Replication Scripts" section in the topic -- "Programming Replication Using System Stored Procedures". USE master DECLARE @password nvarchar(50) = “YourLongP@$$w0rdHere” EXEC sp_changedistributor_password @password GO
Only members of the sysadmin fixed server role can execute sp_changedistributor_password.