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
Like us on FaceBook | Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook
Follow me on Twitter | Follow me on FaceBook