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