| title | sp_changedistpublisher (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 7ef5c89d-faaa-4f8e-aef7-00649ebc8bc9 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEappliesto-ss-asdbmi-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' ]
[ , [ @storage_connection_string = ] 'storage_connection_string']
[ @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.
[ @storage_connection_string = ] 'storage_connection_string'
Is required for SQL Database managed instance, should match the access key for the Azure SQL Database storage volume.
[!INCLUDEAzure SQL Database link]
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. | |
| storage_connection_string | Access key | The access key for the working directory when the database is Azure SQL Database Managed Instance. |
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)