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

Asked 21/8, 2014 at 14:51 Answered 21/8, 2014 at 14:55

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

Philodendron answered 21/8, 2014 at 14:51 Comment(0)

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.

Torin answered 21/8, 2014 at 14:55 Comment(2)

Check the is_read_committed_snapshot_on column. When value is 1 it's on. – Torin 21/8, 2014 at 14:59

Ok. Thanks. Great for all your quick help. – Philodendron 21/8, 2014 at 15:0