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?

score 10 · Accepted Answer · answered Aug 21 '14 at 14:55

10

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.

answered Aug 21 '14 at 14:55

David Brabant

Check the is_read_committed_snapshot_on column. When value is 1 it's on. – David Brabant Aug 21 '14 at 14:59
Ok. Thanks. Great for all your quick help. – Sunil Aug 21 '14 at 15:00

1 Answers1