Friday, April 12, 2013

MSSQL: Transaction was deadlocked

For the past few weeks i’ve encountered mssql deadlock error in my application. The exception was: “Transaction (Process ID ...) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.” So what is this deadlock and how to find more information about it?