Microsoft KB Archive/45548
The information in this article applies to:
SQL Server cannot detect deadlocks by simple timeout. SQL Server keeps track of which locks belong to which processes. When a request for a lock is blocked by another process that already holds a lock on that object, SQL Server checks to see if that other process is waiting for a lock that belongs to this process. In fact, it checks all waiting processes so that even transitive deadlocks are detected.
Keywords : kbusage SSrvServer
Last Reviewed: March 6, 1999