sp_changedistpublisher (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions

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=** ] 'value'
    Is the value for the given property. value is nvarchar(255), with a default of NULL.

    This table describes the properties of Publishers and the values for those properties.

    Property

    Values

    Description

    active

    true

    Activates the Publisher.

     

    false

    Deactivates the publisher

    distribution_db

     

    Name of the distribution database.

    login

     

    Login name.

    password

     

    Strong password for the supplied login.

    security_mode

    1

    Use Windows Authentication when connecting to the Publisher. This cannot be changed for a non-Microsoft SQL Server publisher.

     

    0

    Use SQL Server Authentication when connecting to the Publisher. This cannot be changed for a non-SQL Server publisher.

    working_directory

     

    Working directory used to store data and schema files for the publication.

    NULL (default)

     

    All available property options are printed.

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.