The SubscriptionType specifies direction and Publisher-visibility for a replication subscription.
| DistributionSubscription Object | TransPullSubscription Object |
| MergePullSubscription Object | TransSubscription Object |
| MergeSubscription Object |
object.SubscriptionType [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying a type of subscription as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOSubscription_All | 3 | SQLDMOSubscription_Pull and SQLDMOSubscription_ Anonymous combined by using an Or. |
| SQLDMOSubscription_Anonymous | 2 | Subscription is anonymous. Valid for Subscriber-originated subscriptions only. |
| SQLDMOSubscription_Default | 0 | SQLDMOSubscription_Push |
| SQLDMOSubscription_Pull | 1 | Subscription is Subscriber-originated. |
| SQLDMOSubscription_Push | 0 | Subscription is Publisher originated. |
The SQL-DMO object used to define a subscription determines whether the subscription is Publisher-originated (push) or Subscriber-initiated (pull). When using SQL-DMO to configure replication, use SubscriptionType when creating anonymous pull subscriptions.
Long, enumerated.
Read-only for the MergeSubscription and TransSubscription objects. Read/write for all other SQL-DMO subscription objects when using the object to create a replication subscription.
HRESULT GetSubscriptionType(
SQLDMO_SUBSCRIPTION_TYPE* pRetVal);
HRESULT SetSubscriptionType(
SQLDMO_SUBSCRIPTION_TYPE NewValue);