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, ...

The answer is yes. This may be obvious to some, but may not be so obvious to many. It’s good to look at a specific example to see how it may happen.   First of all, let’s be precise about what we are talking about here. Assume that we have a table called Junk. We are running a query on the table as follows:   SELECT * FROM Junk ...