다음을 통해 공유


Distributor Object

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

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

현재 개체를 보여 주는 SQL-DMO 개체 모델

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

주의

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 versions 7.0 and later. However, the Distributor2 object extends the functionality of the Distributor object for use with features that were introduced in SQL Server 2000.

참고 항목

참조

Distributor2 Object

도움말 및 정보

SQL Server 2005 지원 받기