Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

  New Information - SQL Server 2000 SP3.

Changes the password for a Distributor. This stored procedure is executed at the Publisher on the distribution 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.

Security Note  NULL passwords are not recommended.

Return Code Values

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.

See Also

System Stored Procedures

© 2015 Microsoft