Viewing the isolation level

 View the isolation level for the current connection using the CONNECTION_PROPERTY function
  • Execute the following statement:

    SELECT CONNECTION_PROPERTY('isolation_level');