A question from my class:

How to find SQL Server current isolation level of the session?

Thanks to DMVs.

SQL Server Current isolation level

where:

1 = READ UNCOMMITTED

2 = READ COMMITTED

3 = REPEATABLE READ

4 = SERIALIZABLE

5 = SNAPSHOT