SQL-DMO
SubscriberType Property (TransPullSubscription, TransSubscription)
The SubscriberType property defines subscription behavior when data maintained in a subscribed-to article is altered at the Subscriber.
Applies To
| TransPullSubscription Object | TransSubscription 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_TRANSUBSCRIBER_TYPE* pRetVal);
HRESULT SetSubscriberType(
SQLDMO_TRANSUBSCRIBER_TYPE NewValue);
Settings
| Constant | Value | Description |
|---|---|---|
| SQLDMOTranSubscriber_Default | 0 | SQLDMOTranSubscriber_ReadOnly |
| SQLDMOTranSubscriber_ReadOnly | 0 | 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. |