Deadlocked | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Hi– 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.
Regards, -=Ajjee

Check out the tips on deadlocks here on the site:
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?

Thanks for your help will try that…..