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: