• Does the WITH (NOLOCK) option work with sql server 2005 ?

    Or is it depricated ?

    I was facing some serious deadlock issues in a high transaction table, i was not bothered about inaccurate data, i added nolock to a select statement.

    Even after i added nolock directive to my select, this select statement becomes a deadlock victim at times.

    I do not understand why and how can this happen? ( a select with nolock is not locking anything at all, how does it participate in a dead lock situation ? )

    can someone throw some light on this please ?

    fyi. there could be other transactions that update the data that the select with nolock transaction is trying to select.

    Thanks in adv.

    appreciate your help.