Updates the properties of the distribution Publisher.
sp_changedistpublisher [@publisher =] 'publisher'
[,[@property =] 'property'] [,[@value =] 'value']
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. |
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.
sp_adddistpublisher | sp_helpdistpublisher |
sp_dropdistpublisher | System Stored Procedures |