Transaction (Process ID 120) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
<p>In our organization there is an old desktop application built in c# which connects sql server db.
It is running since 2008.
Now suddenly it is giving an error </p>

<pre><code>Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
</code></pre>

<p>this can be solved in code level, which I got from other similar posts. The problem here is I dont have source code of the application but I have access to DB. Can this be solved on Db level. Any settings in SQl Server 2005 which can prevent this error. </p>