Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_changedistpublisher (Transact-SQL)


Applies To: SQL Server

Changes the properties of the distribution Publisher. This stored procedure is executed at the Distributor on any database.

Topic link icon 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.

activetrueActivates the Publisher.
falseDeactivates the publisher
distribution_dbName of the distribution database.
loginLogin name.
passwordStrong password for the supplied login.
security_mode1Use Windows Authentication when connecting to the Publisher. This cannot be changed for a non-Microsoft SQL Server publisher.
0Use SQL Server Authentication when connecting to the Publisher. This cannot be changed for a non-SQL Server publisher.
working_directoryWorking 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)

Community Additions

© 2016 Microsoft