SQL Server Performance Forum – Threads Archive
DeadlockedHi– I am running a very complex SP most of the time its fine but some times its fails with the following error: "Transaction (Process ID 12) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." Please help me to trace these error and remove them.
Check out the tips on deadlocks here on the site:http://www.sql-server-performance.com/deadlocks.asp —
Microsoft SQL Server MVP
Heute schon gebloggt?http://www.insidesql.de/blogs
Thanks for your help will try that…..