Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_changedistributor_password

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.

Syntax

sp_changedistributor_password [ @password = ] 'password'

Arguments

[@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)

Remarks

sp_changedistributor_password is used in all types of replication.

Permissions

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

See Also

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.