![]() This row already has an exclusive lock for John. It tries to take a shared lock to read the row.It acquires an intent shared (IS) lock on the customer table and the page that contains the record as per the where clause.It prevents any other user from modifying the row data until process A releases its lock. It further takes an exclusive (X) lock on the row that John wants to update.It takes an intent exclusive (IX) lock on the customer table and page that contains the record.In this case, SQL Server uses the following locks for both John and Peter. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |