How to find the Isolation level being used by a Database?

April 21, 2016 Sarabpreet Singh Anand

Hi Friends,

Recently i was preparing a Dashboard sheet for one of our critical Box. The Client was having a long list of Requirements and one odd requirement was to embbed the Isolation level being used for every Database. This was a unique requirement for me and i never knew how to get this, but within 5 minutes of searching i came to know about an interesting Command which returns this info along with other useful stuff.

The command is
DBCC UserOptions
This command also tells you about certain DateFormats and ANSI Settings.

The below pic shows an output of one of my Database where the isolation level is set to Snapshot

Hope this will help you in some way.

Regards

Sarabpreet Anand