|
Home > Archive > MS SQL Server > August 2005 > Given a line # - How do I determine the statement within a Stored Proc?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Given a line # - How do I determine the statement within a Stored Proc?
|
|
|
| I am getting a deadlock message and it is referencing the following:
SPID: 192 ECID: 0 Statement Type: DELETE Line #: 77
When I execute a sp_helptext on the SP in question - there are 4 delete
statements but none of these are on line 77 of the sp_helptext output. In
fact line # 77 of the sp_helptext output is actually the very last END
statement in the SP.
Is there any way to tell what the statement is that corresponds to line #
77?
Thanks in advance,
Tom
| |
|
| look like line 1 starts at the first statement inside the SP, after these
lines
CREATE PROC xxx
AS
SET NOCOUNT ON
and any blank line.
hth,
"TJT" <TJT@nospam.com> wrote in message
news:uhaG8ZkrFHA.260@TK2MSFTNGP11.phx.gbl...
>I am getting a deadlock message and it is referencing the following:
> SPID: 192 ECID: 0 Statement Type: DELETE Line #: 77
>
> When I execute a sp_helptext on the SP in question - there are 4 delete
> statements but none of these are on line 77 of the sp_helptext output. In
> fact line # 77 of the sp_helptext output is actually the very last END
> statement in the SP.
>
> Is there any way to tell what the statement is that corresponds to line #
> 77?
>
> Thanks in advance,
> Tom
>
>
|
|
|
|
|