How to Modify Publisher and Distributor Properties (Transact-SQL)

To view Distributor properties

1. Execute sp_helpdistributor to list information about the Distributor, distribution database, working directory, and SQL Server Agent user account.
   
   
2. Execute sp_helpdistributiondb to return properties of the specified distribution database.

To modify a Distributor

1. Execute sp_changedistributor_property to modify Distributor properties.
   
   
2. Execute sp_changedistributiondb to modify distribution database properties.

To add a password to a Distributor

• Execute sp_add_distributor specifying the password parameter.

To change a password on a Distributor

• Execute sp_changedistributor_password.

To create a new distribution database

• Execute sp_adddistributiondb to create a new distribution database and install the distribution schema.

To add a Publisher to a distribution database

• Execute sp_adddistpublisher n times to define each Publisher that uses the Distributor.

To remove a Publisher from a distribution database

• Execute sp_dropdistpublisher to drop a Publisher that is also the Distributor.