SQL Server Snapshot Isolation

--Script to verify snapshot isolation enabled

SELECT name

, s.snapshot_isolation_state

, snapshot_isolation_state_desc

, is_read_committed_snapshot_on

FROM sys.databases s

go

---

--Script to enable snapshot isolation level

ALTER DATABASE Compass_QA

SET ALLOW_SNAPSHOT_ISOLATION ON

go

---

--Script to disable snapshot isolation level

ALTER DATABASE Compass_QA

SET ALLOW_SNAPSHOT_ISOLATION OFF

go

---