Changes the password for a Distributor.
sp_changedistributor_password [@password =] 'password'
0 (success) or 1 (failure)
sp_changedistributor_password is used in all types of replication.
Only members of the sysadmin fixed server role can execute sp_changedistributor_password.
System Stored Procedures |