Home Forums SQL Server 2005 Administering How to detect dead lock from SQL Server side RE: How to detect dead lock from SQL Server side

  • June 10, 2008 at 9:42 pm

    #827043

    Please refer this link which might help you begin with analyzing deadlock.

    http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=Troubleshoot%20Deadlocking%20in%20SQL%20Server

    You need to make use of the trace flag 1222 and 3605 to analyze the same.

    [font="Verdana"]- Deepak[/font]