SQL Server Snapshot Isolation – Is it on?


How do you check whether snapshot isolation is on or off for a particular SQL Server database using SQL Server Management Studio?  We’ve never been able to find it but this quick T-SQL query will show you the answer.   (Also check out our post on checking whether Read Committed Snapshot is on):

SELECT
name
,snapshot_isolation_state_desc
FROM
sys.databases AS d
ORDER BY
d.name


Leave a Reply

Your email address will not be published.