You can assign the current isolation level to variable by using the GET TRANSACTION statement. The following is a statement that verifies the isolation level. variable.
GET TRANSACTION ISOLATION LEVEL [ { INTO | TO } variable ] [ ; ]
GET TRANSACTION ISOLATION LEVEL;
Result
=============
READ COMMITTED SCHEMA, READ UNCOMMITTED INSTANCES