Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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');