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:

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

2014-12-18