Click here to Skip to main content
15,882,278 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:

In database, while working in One insert query coming deadlock error.
How to solve this issue?

Advance Thanks for positive reply.
PIEBALDconsult 30-Jul-14 11:30am    
Is there a trigger involved?

1 solution

The insert command might be trying to lock one index or both indexes and the indexes are locked for the other thread.

A huge mistake is when you lock resources for queries in different order of each thread. Check the order of the queries and lock the resources in the same order in all of the threads
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900