deadlock

Occurs when one user has locked a data page and tries to lock another page or row that is locked by a second user who, in turn, is trying to lock the page or row that is locked by the first user. While such occurrences are rare, the longer that a page, row, table, or file is locked, the greater the chance of a deadly embrace (an unresolved deadlock condition that blocks two or more applications).