Replication Transactional Subscriber Constants (SQLDMO_TRANSUBSCRIBER_TYPE)
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.
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 |
A transactional immediate updating subscriberwith the capability to fail over to a queued Subscriber. |
SQLDMOTranSubscriber_Max |
3 |
SQLDMOTranSubscriber_Synchronous. |
SQLDMOTranSubscriber_Min |
0 |
SQLDMOTranSubscriber_ReadOnly. |
SQLDMOTranSubscriber_Queued |
2 |
The 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 |
The 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 |
The value is not valid. |