Distributor Object (SQL-DMO)

The Distributor object represents the replication Distributor for a server running Microsoft® SQL Server™.

Remarks

With the Distributor object, you can:

• Install a local Distributor or configure remote distribution for a Publisher.
• Uninstall a local Distributor or stop remote distribution.

To install a local Distributor and distribution database

1. Create a new DistributionDatabase object.
2. Set the Name property to the name of the new distribution database.
3. Add the DistributionDatabase object to the DistributionDatabases collection of a connected Distributor object.
4. Set the DistributionServer property of a connected Distributor object to the name of the local server running SQL Server (which is available in the TrueName property of a connected SQLServer object).
5. Use the Install method of the connected Distributor object.

To uninstall a local Distributor and distribution database

1. Use the Uninstall method of a connected Distributor object.

Methods

Properties