Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The SubscriptionType specifies direction and Publisher-visibility for a replication subscription.
Syntax
object
.SubscriptionType [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list.
- value
A 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 Distributed Management Objects (SQL-DMO) subscription objects when the object is used 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 are combined using an OR logical operator. |
SQLDMOSubscription_/Anonymous |
2 |
Subscription is anonymous. It is valid for Subscriber-originated subscriptions only. |
SQLDMOSubscription_Default |
0 |
SQLDMOSubscription_Push. |
SQLDMOSubscription_Pull |
1 |
The subscription is Subscriber-originated. |
SQLDMOSubscription_Push |
0 |
The 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.
Applies To:
|