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
Director – eDominer Systems, Peopleware India, SQLMaestros

Follow me on Twitter | Follow me on FaceBook | Connect on LinkedIn | Google+
FB page | Know more about me

SQL Server Training, SQL DBA, DEV, Hyderabad July 2014
Who installed SQL Server (SQL Server installation details)