Viewing the isolation level

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');