sp-changedistributor-password-transact-sql.md

title	sp_changedistributor_password (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	sp_changedistributor_password sp_changedistributor_password_TSQL
helpviewer_keywords	sp_changedistributor_password
ms.assetid	4a496e60-414a-4026-ba7a-3e89391d39b7
caps.latest.revision	31
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sp_changedistributor_password (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Changes the password for a Distributor. This stored procedure is executed at the Distributor on any database.

Transact-SQL Syntax Conventions

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.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_changedistributor_password is used in all types of replication.

Example

[!code-sqlHowTo#sp_changedistributor_password]

Permissions

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

See Also

View and Modify Replication Security Settings
Secure the Distributor
sp_adddistributor (Transact-SQL)
Replication Stored Procedures (Transact-SQL)