Explanation/Reference:
Explanation:
Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server.
Using SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis.
References: http://msdn.microsoft.com/en-us/library/ms188246.aspx