Hi, I occasionally get the following message on our production sql server box.
Transaction (Process ID 787) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock.
I can find out the query that was chosen as the victim. How can I find out the other query that is part of the deadlock? Also, how can we fix this?