Determining your session’s transaction isolation level

A question came up from a developer yesterday. He could see how to set a transaction isolation level but didn’t know how to determine the current transaction isolation level. That detail is available in the sys.dm_exec_sessions DMV.

Here’s an example:

image

 

And if you are running SQL Server 2012, you could always use CHOOSE instead:

image

3 thoughts on “Determining your session’s transaction isolation level”

Leave a Reply

Your email address will not be published.