Return to Question

Update:

Adding UPDLOCK has no effect (X on object still observable after IX).

Adding UPDLOCK has no effect (X on object still observable after IX).

So, it seems that forcing seek not necessarily guarantee deadlocks absence. I'm not confident, that having clustered index guarantee something. Or does it?

The question about eligibility of placing X lock on object after IX still open. If it is eligible. How can one avoid object locking?

So, it seems that forcing seek not necessarily guarantee granular locks (and deadlocks absence hence). I'm not confident, that having clustered index guarantee granular locking. Or does it?

The question about eligibility of placing X lock on object after IX still open. And if it is eligible, is there something that one can do to prevent object locking?