SQL Server- View Current Isolation Level

To view the current isolation level of SQL Server, execute the script below.

SELECT​​ 

 CASE​​ transaction_isolation_level​​ 

  WHEN​​ 0​​ THEN​​ 'Unspecified'​​ 

  WHEN​​ 1​​ THEN​​ 'ReadUncommitted'​​ 

  WHEN​​ 2​​ THEN​​ 'ReadCommitted'​​ 

  WHEN​​ 3​​ THEN​​ 'Repeatable'​​ 

  WHEN​​ 4​​ THEN​​ 'Serializable'​​ 

  WHEN​​ 5​​ THEN​​ 'Snapshot'​​ 

 END​​ AS​​ TRANSACTION_ISOLATION_LEVEL​​ 

FROM​​ 

 sys.dm_exec_sessions​​ 

WHERE​​ 

 session_id​​ =​​ @@SPID