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

By Phil Steffek

Phil Steffek is a professional sumo wrestler who is hoping to represent the U.S. in the next Olympics. During the off season Phil is a Data Architect working on transactional databases, data warehouse implementations, and all aspects of business intelligence. Also, Phil is not really a sumo wrestler. You can get to know a bit more about my non-sumo doings by checking out my LinkedIn Page

Leave a comment

Your email address will not be published. Required fields are marked *