Browse by Tags

• Blocking
• Locking
• Query Processing
• Snapshot Isolation

• Snapshot isolation and SQL Server 2000 compatibility level

  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 Read More... Posted Friday, September 25, 2009 9:54 AM by Linchi Shea | 2 Comments Filed under: Blocking, Isolation Levels, Locking, Query Processing, Snapshot Isolation