SQL SERVER – How to Check Snapshot Isolation State of Database
It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same. SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed_snapshot_on FROM sys.databases s Upon running above code it will return the results describing the status of the isolation level for your…
Read More
