Verify if SNAPSHOT isolation level is on in SQL Server 2008 R2

Question

What SQL will I execute in SSMS for SQL Server 2008 R2 to know if SNAPSHOT isolation level is turned on in the database?

Answer 1

SELECT snapshot_isolation_state_desc from sys.databases 
where name='<your database name here>'

will allow you to check if it is turned on or not.