Post reply

How to change locking mode in 2005?

  • June 12, 2008 at 9:21 am

    #827940

    Jack Corbett (6/11/2008)

    READ COMMITTED is the default Isolation Level in SQL Server. This is why a select will not finish until any exclusive locks are released.

    For example in my example, if I were to do a select * from test.test where test_id = 100, I may get the result immediately because SQL Server may take page locks and I could be on a different page (unlikely with 100 4 byte rows) or row locks so that the row I want is not locked.

    Hello,

    It seems that in my implementation of SQL Server 2005 READ COMMITTED is NOT the default isolation level. Is there an ini file or some other method where I can set this as a default setting for all future databases?

    Thanks,

    Gabor

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply