Viewing the isolation level

Use the CONNECTION_PROPERTY function to view the isolation level for the current connection.

Prerequisites

You must be connected to a database.

Execute the following statement:

SELECT CONNECTION_PROPERTY( 'isolation_level' );

The isolation level for the current connection is returned.