How to find the Isolation level being used by a Database?
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
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.