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