TransPullSubscriptions Collection (SQL-DMO)

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

Remarks

With the TransPullSubscriptions collection, you can:

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

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

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


Note Removing a subscription by 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)

Methods
Add Method Remove Method (Collections)
Item Method Script Method (Replication Objects)
Refresh Method  

Properties

Count Property

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.