Thanks in advance for your help. Any help is appreciated.
I have a urgent production deadlock issue. Because of the deadlock, one of the import applications is killed by SQL Server.
I tried to find out the reason of deadlock. I run the SQL Profiler and I use the following eventclass:
Exec Prepared SQL
In the trace log file, I can only found a line under "Lockeadlock" eventclass, I can't find anything under "Lockeadlock Chain" eventclass.
Here is the info from that line:
StartTime: 2006-06-06 13:01:12.053
EndTime: 2006-06-06 13:01:14.100