SQL Server Performance Forum – Threads Archive
Deadlock issueToday when I tried to shrink a DB I got the following error."Error 1205:Transaction(Process ID 97) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.Rerun the transaction"
What is wrong and how.?How to resolve it
As per my knowledge sql server is capable of handling deadlock.But still this error came.
Refer this on how to reduce deadlocks
Madhivanan Failing to plan is Planning to fail
I believe most of your questions within last 2 days seems to be repetitive from your ealier posts.
Anyway you got the answers and follow them. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.