Menu
What SQL will I execute in SSMS for SQL Server 2008 R2 to know if SNAPSHOT isolation level is turned on in the database?
376
Using SQL Server Management StudioIn Object Explorer, connect to the instance of the SQL Server Database Engine and then expand that instance. Expand Databases. Expand Database Snapshots, and select the snapshot you want to view.
Below SQL Server DB level query can be used to check whether read_committed_snapshot is ON/OFF: SELECT IS_READ_COMMITTED_SNAPSHOT_ON FROM SYS.
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.
71
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
