CODEWITHSUNDEEP
sql-server-2008-r2snapshot-isolation
Sunil
Sunil

Reputation: 21406

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

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

Upvotes: 9

Views: 11136

Answers (1)

David Brabant
David Brabant

Reputation: 43539

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.

Upvotes: 15

Related Questions