SQL-DMO

Distributor Object

The Distributor object represents the replication Distributor for an instance of Microsoft® SQL Server™ 2000.

Properties
AgentCheckupInterval Property DistributorInstalled Property
DistributionDatabase Property DistributorLocal Property
DistributionServer Property HasRemoteDistributionPublisher Property
DistributorAvailable Property IsDistributionPublisher Property

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:

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

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