Get the current Isolation Level for the SQL Server database

Often developers would like to know the current Isolation Level for the SQL Server database. You can get this information using DBCC command. Type the following command in the query window.

DBCC USEROPTIONS;

The above command returns the SET options currently active for the current (active) user in SQL Server.

Note:

1. Please don’t use DBCC commands without the prior permission of your DBA(s).
2. Also these commands requires membership in the public roles.
3. Please try in test environment only.
   
   Returns the following information

Happy Learning !!!