DistributionPublications Collection

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The DistributionPublications collection contains DistributionPublication objects that expose the properties of publications managed by the Distributor.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Methods

Add Method

Refresh Method

Item Method

Remove Method (Collections)

解説

With the DistributionPublications collection, you can:

  • Create a Distributor-managed replication publication.
  • Remove a Distributor-managed replication publication.

For more information about Distributor-managed publications, see the DistributionPublication Objectsection.

The Item method of the DistributionPublications collection supports member selection using the publication name or the ordinal position of the object in the collection. Additionally, when using the publication name to select an object from the collection, the Item method allows name qualification of the targeted publication by using the publication database. For example:

Set oDistPublication = oDistPublisher.DistributionPublications("products", "northwind")

The Remove method of the DistributionPublications collection supports member targeting using either the unqualified publication name or the ordinal position of the object in the collection. When using the DistributionPublications collection to remove a publication, it is suggested that you use the Item method of the collection to extract the object referencing the correct publication, then use the Remove method of the DistributionPublication method to remove the targeted publication.