sp_changedistpublisher

Transact-SQL Reference

Transact-SQL Reference

sp_changedistpublisher

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

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

sp_adddistpublisher

sp_dropdistpublisher

sp_helpdistpublisher

System Stored Procedures