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

 

Amit Bansal (SQL MCM, SQL MVP) | Twitter | FaceBook | LinkedIn | FB Page|Ask a SQL Question                                                          Browse more blogs on SQLServerGeeks.com