What is the simplest test to see the snapshot isolation level at work?   There was a question in one of the forums on whether you can use the snapshot isolation level in a SQL Server 2005 database that is in the SQL2000 compatibility level. I don’t know what may be the official answer from the Books Online. It may be documented somewhere, ...