2 types of deadlock errors -- sql server programming

Hassan
6/14/2006 10:39:12 PM

1) Transaction (Process ID 110) was deadlocked on lock resources with
another process and has been chosen as the deadlock victim. Rerun the
transaction.

2) Transaction (Process ID 120) was deadlocked on lock | communication
buffer resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

I think I know the reasons for the first error message.

What are the reasons for the 2nd type of error message ? Are they totally
different from the first ?

Roji. P. Thomas
6/15/2006 12:00:00 AM

Hassan,

They are the same error. A deadlock can occur on a lock, communication
buffer or thread.

--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
[quoted text, click to view]

sql server programming : 2 types of deadlock errors