Error 40001(1205)

  • Hi guys

    working on this Error "40001(1205) : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

    -Front End users getting this error.

    Any Idea how to solve this error ?

    Thanks for Help

  • You are going to want to find out which queries are involved in this: http://msdn.microsoft.com/en-us/library/ms178104.aspx This is a good start. Once you know which queries (or query being run multiple times) are responsible for this, you should look at the query(s) to see if it can be modified to avoid creating a deadlock.

    Jared
    CE - Microsoft

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply