Prev: junction table query
Next: Sql Server 2008 installation problem
From: John Hardin on 29 Mar 2010 13:13
All:

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
EPICOR Retail
web: http://www.epicor.com
voice: (425) 245-1800
fax: (425) 670-1810
email: <jhardin(a)epicor.com>
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.
------------------------------------------------------------------------

 | 
Pages: 1
Prev: junction table query
Next: Sql Server 2008 installation problem