Dead Lock

• Raino

  SSChasing Mays

  Points: 648

  More actions

  October 28, 2003 at 11:10 pm

  #160048

  I am getting an occasional deadlock (SQL 7) with this message:

  Server: Msg 1205, Level 13, State 3, Procedure Order_Line_Xref_Process, Line 96

  Your transaction (process ID #33) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.

  It is getting the deadlock in a select in the stored procedure.

  Any tips on how to troubleshoot this (find the other process) and how to avoid it?

• philcart

  SSC-Forever

  Points: 47794

  More actions

  October 29, 2003 at 3:41 pm

  #480203

  Check "Avoiding Deadlocks" and "Understanding and Avoiding Blocking" in Books online.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface