January 4, 2021 at 12:00 am
Comments posted to this topic are about the item The Update Lock
January 4, 2021 at 2:33 pm
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
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