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

sp_changedistpublisher (Transact-SQL)

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

Topic link iconTransact-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-Microsoft SQL Server publisher.

 

0

Use SQL Server Authentication when connecting to the Publisher. This cannot be changed for a non-SQL Server 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.