SQL Server technical bulletin - How to resolve a deadlock

SQL Server Technical Bulletin Topic covered in this issue: How to resolve a deadlock ... Step 2 Next, you must collect a SQL Profiler trace. If you turn on the deadlock trace flag, you will get most of the required information, but not always.

support.microsoft.com