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.
Execute the following statement:
SELECT CONNECTION_PROPERTY('isolation_level')