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

OBJECT_NAME(@@PROCID)





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

No retrieving dupicate rows
Service Broker - BEGIN DIALOG CONVERSATION @dialog_handle
Performance
Would like an Exists in a Case statement
case and group by problem
Please help - setting order of select in a self-referencing table
how to duplicate my database?
How to find the triggers in a database
Dyanamic Where Clause
How to Restore an Archived Filegroup on Another Server?