SET TRANSACTION SAFENESS
SET TRANSACTION SAFENESS {1SAFE | 2SAFE | DEFAULT}
SET TRANSACTION SAFENESS determines whether the replication protocol is synchronous (2-safe) or asynchronous (1-safe).
▪1-safe: the transaction is first committed at Primary and then transmitted to Secondary
▪2-safe: the transaction is not committed before it has been acknowledged by Secondary (default).
SET TRANSACTION SAFENESS sets the safeness level for the current transaction.
See also