Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Use the CONNECTION_PROPERTY function to view the isolation level for the current connection.
You must be connected to a database.
SELECT CONNECTION_PROPERTY( 'isolation_level' );
The isolation level for the current connection is returned.