SubscriptionType Property

SQL-DMO

SQL-DMO

SubscriptionType Property

The SubscriptionType specifies direction and Publisher-visibility for a replication subscription.

Applies To
DistributionSubscription Object TransPullSubscription Object
MergePullSubscription Object TransSubscription Object
MergeSubscription Object  
Syntax

object.SubscriptionType [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies a type of subscription as described in Settings

Data Type

Long, enumerated

Modifiable

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.

Prototype (C/C++)

HRESULT GetSubscriptionType(
SQLDMO_SUBSCRIPTION_TYPE* pRetVal);

HRESULT SetSubscriptionType(
SQLDMO_SUBSCRIPTION_TYPE NewValue);

Settings
Constant Value Description
SQLDMOSubscription_All 3 SQLDMOSubscription_Pull and SQLDMOSubscription_Anonymous combined using an OR logical operator.
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.

Remarks

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.