Replication Transactional Subscriber Constants (SQLDMO_TRANSUBSCRIBER_TYPE)

SQL-DMO

SQL-DMO

Replication Transactional Subscriber Constants (SQLDMO_TRANSUBSCRIBER_TYPE)

Replication transaction Subscriber constants specify subscription behavior when a Subscriber initiates a change to data in an article image.

Constant Value Description
SQLDMOTranSubscriber_Default 0 SQLDMOTranSubscriber_ReadOnly.
SQLDMOTranSubscriber_Failover 3 Transactional Immediate Updating Subscriber with capability to fail over to queued Subscriber.
SQLDMOTranSubscriber_Max 3 SQLDMOTranSubscriber_Synchronous.
SQLDMOTranSubscriber_Min 0 SQLDMOTranSubscriber_ReadOnly.
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.

See Also

EnableTransSubscription Method

SubscriberType Property (TransPullSubscription, TransSubscription)