0
kicks
In MS SQL Server getting Deadlock details using Traces
To get complete deadlock details the easiest and lighted-waighted method is using Traces#. For this purpose SQL Server have Trace # 1204, 1205. The information can be logged in Error log file using trace #3605.