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.