SQL-DMO
SubscriberType Property (MergePullSubscription, MergeSubscription)
The SubscriberType property defines subscription attributes.
Applies To
| MergePullSubscription Object | MergeSubscription Object |
Syntax
object.SubscriberType [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer or constant value as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write when using the SQL-DMO object to create a subscription.
Read-only when the object references an existing subscription.
Prototype (C/C++)
HRESULT GetSubscriberType(
SQLDMO_MERGESUBSCRIBER_TYPE* pRetVal);
HRESULT SetSubscriberType(
SQLDMO_MERGESUBSCRIBER_TYPE NewValue);
Settings
Set the value argument using these SQLDMO_TRANSUBSCRIBER_TYPE values.
| Constant | Value | Description |
|---|---|---|
| SQLDMOTranSubscriber_Default | 0 | SQLDMOTranSubscriber_ReadOnly. |
| SQLDMOTranSubscriber_Failover | 3 | Transactional Immediate Updating Subscriber with capability to fail over to queued Subscriber. |
| SQLDMOTranSubscriber_Queued | 2 | Subscriber update to a publication article is applied as a queued transaction. |
| SQLDMOTranSubscriber_ReadOnly | 0 | Default. Subscriber update to any publication article affects only the image maintained at the Subscriber. |
| SQLDMOTranSubscriber_Synchronous | 1 | Subscriber update to a publication article is applied in a distributed transaction, updating the Publisher-maintained image for article data or failing entirely. |
| SQLDMOTranSubscriber_Unknown | 256 | Bad or invalid value. |