SQL Server Snapshot Isolation – Is it on? How do you know whether snapshot isolation is on in SQL Server? A quick T-SQL query will show you the answer.