SQL Server Read Committed Snapshot – Is it on?


How do you check whether read committed snapshot is on or off for a particular SQL Server database using SQL Server Management Studio?  We’ve never been able to find it but this quick T-SQL query will show you the answer.   (Also check out our post on checking whether Snapshot Isolation is on):

SELECT
name
,is_read_committed_snapshot_on
FROM
sys.databases AS d
ORDER BY
d.name


Leave a Reply

Your email address will not be published.