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
>
>