Chapter 23: Transactions: Maintaining Data Consistency and Recovery
Finding the status of the
current isolation level
The
global variable @@isolation contains
the current isolation level of your Transact-SQL session. Querying @@isolation returns
the value of the active level (0, 1, or 3). For example:
