Post reply

read committed snapshot with table hint updlock

  • August 24, 2017 at 11:31 pm

    #339465

    Hi,

    Got the following query from our developers.
    Kindly help me resolve if you can.

    The database is set for "read committed snapshot".
    It seems that a Select with updlock should not block another Select, but it does.

    If we give Transaction 1 as:
    begin tran
    select * from T1 with (updlock)

    and Transaction 2 as:
    select * from T1

    Then Transaction 2 is blocked.

    Any ideas?

    Thanks!
    Ashish

  • August 25, 2017 at 11:56 am

    #1956915

    You put an updlock on a table and then want to read from it in a separate transaction?   That just doesn't make any sense.   tablock, perhaps, but not updlock.

    Steve?(aka sgmunson)?:) 🙂 :)?
    Health & Nutrition
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

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