Was this helpful?
Locking
The modify statement requires an exclusive table lock. Other sessions, even those using readlock=nolock, cannot access the table until the transaction containing the modify statement is committed.
Last modified date: 01/30/2023