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):

Published
Categorized as Scripts