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:

select @@isolation
--------
       1
 
(1 row affected)