In MS SQL Server getting Deadlock details using Traces

added by subhashpunia
2/4/2010 5:39:01 AM

2 Kicks, 108 Views

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.