stored procedure -> this.getName()

microsoft.public.sqlserver.programming

21 Dec 2005 5:39 PM

peppi911

hi, ist there a way to retreive the name of the procedure
i am actually in, to send an email with error/name of the procedure?

CREATE PROCEDURE xyz
as

begin

if @error<0
sp_sendMessage @error ??@getName -> xyz??

end

thanks, mike

21 Dec 2005 6:06 PM

Aaron Bertrand [SQL Server MVP]

OBJECT_NAME(@@PROCID)

<peppi***@hotmail.com> wrote in message
Show quote

news:1135186754.875428.109500@g44g2000cwa.googlegroups.com...
>
> hi, ist there a way to retreive the name of the procedure
> i am actually in, to send an email with error/name of the procedure?
>
> CREATE PROCEDURE xyz
> as
>
> begin
>
> if @error<0
> sp_sendMessage @error ??@getName -> xyz??
>
> end
>
> thanks, mike
>