How to view or modify 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.
See Also
Modifying Distributor and Publisher Properties sp_helpdistributiondb
sp_changedistributiondb sp_helpdistributor
sp_changedistributor_property  

  


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