次の方法で共有


TransPullSubscriptions Collection

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

The TransPullSubscriptions collection contains TransPullSubscription objects that reference Subscriber-originated (pull) subscriptions to publications defined on other data sources.

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

Properties

説明

With the TransPullSubscriptions collection, you can:

  • Subscribe to a transactional or snapshot publication of another data source in an organization.

  • Generate a Transact-SQL script that can be used as part of administering all of an installation's pull subscriptions to transactional and snapshot publications.

  • Remove a pull subscription to a transactional or snapshot publication.

For more information about creating pull subscriptions to transactional or snapshot replication publications using the TransPullSubscription object and TransPullSubscriptions collection, see TransPullSubscription Object.

To remove a pull subscription to a transactional or snapshot replication publication

  • Use the Remove method of the TransPullSubscriptions collection, as in:

    oRepDb.TransPullSubscriptions.Remove("[SEATTLE1_Northwind_Trans]")
    
    注意注意

    Removing a subscription using the Remove method of the TransPullSubscriptionscollection does not remove the replicated copy of the publication articles at the Subscriber.

When using the Item or Remove method, the TransPullSubscriptions collection supports member identification using either name or ordinal reference syntax. For example:

Set oTransPullSubscription = oReplicationDatabase.TransPullSubscriptions("[LONDON2_Northwind_Snap]")

Or:

Set oTransPullSubscription = oReplicationDatabase.TransPullSubscriptions(2)