You can inspect the isolation level of the current connection using the CONNECTION_PROPERTY function.

♦  To view the isolation level for the current connection

• Execute the following statement:

  SELECT CONNECTION_PROPERTY('isolation_level');