Distributor Object

SQL-DMO

SQL-DMO
Methods
ChangeAgentProfile Method EnumSnapshotAgentViews Method
CleanUpDistributionPublisherByName Method EnumThirdPartyPublications Method
CreateAgentProfile Method GetAgentsStatus Method (Distributor)
DeleteAgentProfile Method Install Method
EnumAgentProfiles Method Refresh Method
EnumAgentParameters Method RemoveDefunctAnonymousSubscriptionMethod
EnumDistributionAgentViews Method Script Method (Replication Objects)
EnumLogReaderAgentViews Method SetUpDistributorPassword Method
EnumMergeAgentViews Method Uninstall Method
UpdateDefaultAgentProfile Method UpdateAgentProfile Method

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 instance of SQL Server (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

  • Use the Uninstall method of a connected Distributor object.

Note  The Distributor object is compatible with instances of SQL Server 2000 and SQL Server version 7.0. However, the Distributor2 object extends the functionality of the Distributor object for use with features that are new in SQL Server 2000.

See Also

Publishers, Distributors, and Subscribers

Distributor2 Object