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.

Two exceptions are the modify to table_debug variant, which takes a shared table lock, and the concurrent_updates option, which takes only a brief exclusive lock at the end of the modify operation.