Post reply

The Update Lock

  • January 4, 2021 at 12:00 am

    #3816700

    Comments posted to this topic are about the item The Update Lock

  • January 4, 2021 at 2:33 pm

    #3827099

    Am I missing something here?

    If I am reading this correctly, Microsoft is saying that an Update lock is converted to an Exclusive lock.

    "Only one transaction can obtain an update (U) lock to a resource at a time. If a transaction modifies a resource, the update (U) lock is converted to an exclusive (X) lock."

    I read it as I need to know that my Update lock will be converted to an Exclusive lock.

    "To avoid this potential deadlock problem, update (U) locks are used. Only one transaction can obtain an update (U) lock to a resource at a time. If a transaction modifies a resource, the update (U) lock is converted to an exclusive (X) lock."

  • January 4, 2021 at 4:42 pm

    #3827152

    Not sure what your question is. You need an exclusive lock to make a change. You don't do anything, but the server cannot complete your work to get the exclusive lock. You can't get that exclusive lock without the update lock

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

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