From: John Hardin on

I'm troubleshooting a deadlock between SPs, and I'm seeing information in
the 1204 log output that makes no sense:

.... spid4 SPID: 61 ECID: 0 Statement Type: SELECT Line #: 53
.... spid4 Input Buf: RPC Event: le_insert_customer_$sp;1

Line 53 of that SP is up in the declarations of the SP parameters. How can
there be a deadlock at that point?

For the purposes of interpreting 1204 output, are there any special rules
for determining which line number in the SP the log is actually referring
to? Do you start counting from the CREATE PROC line? Or the first line after
the parameter declarations? Or what?

John Hardin KA7OHZ
Senior Applications Developer, BI Specialist
voice: (425) 245-1800
fax: (425) 670-1810
email: <jhardin(a)>
20818 44th Ave. W., Suite 270
Lynnwood, WA 98036 USA
Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA
The first time I saw a bagpipe, I thought the player was torturing an
octopus. I was amazed they could scream so loudly.