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
sp_adddistpublisher sp_helpdistpublisher
sp_dropdistpublisher System Stored Procedures

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.