Exclusive locks that occur with some SQL statements

When you execute an INSERT, UPDATE, or DELETE statement, the database server uses exclusive locks. An exclusive lock means that no other users can update or delete the item until the database server removes the lock. In addition, no other users can view the row unless they are using the Dirty Read isolation level.

When the database server removes the exclusive lock depends on whether the database supports transaction logging.

For more information about these exclusive locks, see Locks placed with INSERT, UPDATE, and DELETE statements.