다음을 통해 공유

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

Count Property

 

Methods

Add Method

Remove Method (Collections)

Item Method

Script Method (Replication Objects)

Refresh Method

 

주의

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 TransPullSubscriptions collection 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)