Home Forums SQL Server 2008 SQL Server 2008 - General Changing isolation level RE: Changing isolation level

  • May 3, 2015 at 4:35 am

    #1795222

    GilaMonster (5/2/2015)

    With the SOLE exception of read committed snapshot, isolation levels are effective from the SET TRANSACTION ISOLATION LEVEL statement until the end of the batch or until the isolation level is changed.

    As for limitations, please, please, please do some reading on these before you just go and turn them on.

    Further on Gail's response, this book, Understanding SQL Server Concurrency is a good place to start!

    😎