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)
For more information about isolation levels and locking, see the Performance and Tuning Guide.
