.png)
sp_changedistributor_password (Transact-SQL)
SQL Server 2008 R2
Changes the password for a Distributor. This stored procedure is executed at the Distributor on any database.
-- 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 EXEC sp_changedistributor_password $(Password) GO
