Error 40001(1205)

Ankit,

I would review this tip - http://www.mssqltips.com/sqlservertip/1036/finding-and-troubleshooting-sql-server-deadlocks/ for an explanation of the SQL Server deadlock issue.

I would review these tips for a solution - http://www.mssqltips.com/sql-server-tip-category/61/locking-and-blocking/.

HTH.

Thank you,
Jeremy Kadlec

THanks Jeremy..

Here is my situation:

the front end users some times getting this error "Error 40001(1205) : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

SO by the time when i get messge and check in error log i can find deadlock details but nothing is bad happening even also . 

Any solution how to avoid this error at front end user side?

Ankit,

To correct the error and prevent the issue all together, I would reference the resources I provided.

To display a more user friendly error message, I would revisit the error handling in your front end code and see how you can return a more user friendly message to the users.

Thank you,
Jeremy Kadlec