SubscriptionType Property (SQL-DMO)

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]

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

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.

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.

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);

  


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