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.