Home Forums SQL Server 2005 Development Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction RE: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

  • September 15, 2008 at 11:48 pm

    #872135

    The tips to resolve this type of errors can be found in this link.

    http://blog.sqlauthority.com/2007/05/16/sql-server-fix-error-1205-transaction-process-id-was-deadlocked-on-resources-with-another-process-and-has-been-chosen-as-the-deadlock-victim-rerun-the-transaction/

    Can you please tell me that how can I identify during the production that which process caused the deadlock?

    Regards,

    Gourav