Chapter 20: Transactions: Maintaining Data Consistency and Recovery
Finding the status of the
current transaction mode
You can check the global variable @@tranchained to
determine Adaptive Server’s current transaction mode. select @@tranchained returns
0 for unchained mode or 1 for chained mode.
