sp_changedistpublisher (T-SQL)

Updates the properties of the distribution Publisher.

Syntax

sp_changedistpublisher [@publisher =] 'publisher'
    [,[@property =] 'property'] [,[@value =] 'value']

Arguments

[@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	Description
active	Active status value.
distribution_db	Distribution database status value.
login	Login status value.
password	Password status value.
security_mode	Security mode status value.
working_directory	Working directory status value.
NULL (default)	All available property options are printed.

[@value =] 'value'

Is the value for the given property. value is nvarchar(255), with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_changedistpublisher is used in all types of replication.

Permissions

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

See Also