Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
How To Find Out If READ COMMITTED SNAPSHOT Has Been Enabled For Your Database?
From Wiki
You want to quickly find out if READ_COMMITTED_SNAPSHOT has been enabled for your database, here is a way to do it.
- SELECT name,
- CASE is_read_committed_snapshot_on
- WHEN 1 THEN 'yes' ELSE 'no' END AS Read_Committed_Snapshot_Enabled
- FROM sys.databases
- WHERE name = DB_NAME()
If you want find out the same information for all the databases on your server leave out the WHERE clause
- SELECT name,
- CASE is_read_committed_snapshot_on
- WHEN 1 THEN 'yes' ELSE 'no' END AS Read_Committed_Snapshot_Enabled
- FROM sys.databases
Contributed by: --SQLDenis 14:42, 9 September 2008 (GMT)
Part of SQL Server Admin Hacks
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.