ASA SQL User's Guide
  Using Transactions and Isolation Levels
    Isolation levels and consistency

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