Linchi Shea : Isolation Levels, Query Processing, Blockinghttp://sqlblog.com/blogs/linchi_shea/archive/tags/Isolation+Levels/Query+Processing/Blocking/default.aspxTags: Isolation Levels, Query Processing, BlockingenCommunityServer 2.1 SP2 (Build: 61129.1)Snapshot isolation and SQL Server 2000 compatibility levelhttp://sqlblog.com/blogs/linchi_shea/archive/2009/09/25/snapshot-isolation-and-sql-server-2000-compatibility-level.aspxFri, 25 Sep 2009 12:54:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:16986Linchi Shea2http://sqlblog.com/blogs/linchi_shea/comments/16986.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=16986What 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...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2009/09/25/snapshot-isolation-and-sql-server-2000-compatibility-level.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=16986" width="1" height="1">Query ProcessingBlockingLockingSnapshot IsolationIsolation Levels