| title | sp_changedistpublisher (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 7ef5c89d-faaa-4f8e-aef7-00649ebc8bc9 | ||
| caps.latest.revision | 36 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Changes the properties of the distribution Publisher. This stored procedure is executed at the Distributor on any database.
Transact-SQL Syntax Conventions
sp_changedistpublisher [ @publisher = ] 'publisher'
[ , [ @property = ] 'property' ]
[ , [ @value = ] 'value' ]
[ @publisher= ] 'publisher'
Is the Publisher name. publisher is sysname, with no default.
[ @property= ] 'property'
Is a property to change for the given Publisher. property is sysname and can be one of these values.
[ @value= ] 'value'
Is the value for the given property. value is nvarchar(255), with a default of NULL.
This table describes the properties of Publishers and the values for those properties.
| Property | Values | Description |
|---|---|---|
| active | true | Activates the Publisher. |
| false | Deactivates the publisher | |
| distribution_db | Name of the distribution database. | |
| login | Login name. | |
| password | Strong password for the supplied login. | |
| security_mode | 1 | Use Windows Authentication when connecting to the Publisher. This cannot be changed for a non-[!INCLUDEmsCoName] [!INCLUDEssNoVersion] publisher. |
| 0 | Use [!INCLUDEssNoVersion] Authentication when connecting to the Publisher. This cannot be changed for a non-[!INCLUDEssNoVersion] publisher. | |
| working_directory | Working directory used to store data and schema files for the publication. | |
| NULL (default) | All available property options are printed. |
0 (success) or 1 (failure)
sp_changedistpublisher is used in all types of replication.
Only members of the sysadmin fixed server role can execute sp_changedistpublisher.
View and Modify Distributor and Publisher Properties
sp_adddistpublisher (Transact-SQL)
sp_dropdistpublisher (Transact-SQL)
sp_helpdistpublisher (Transact-SQL)
System Stored Procedures (Transact-SQL)