Tag Archives: DBCC TRACEON 1204

How to trace Deadlock in SQL Server ?

What is a DEAD LOCK in SQL Server? When two or more transactions conflict in such a way that each is waiting for the other before they proceed. For instance, Transaction A might have a lock on Record 1 while trying to write to Record 2, while Transaction B has a lock on Record 2 [...]