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