Does a stored procedure know its own name?

• Yamini Arora

  SSC Enthusiast

  Points: 162

  More actions

  April 10, 2008 at 10:53 pm

  #185312

  I have some stored procedures that call another SP which sends out mails(SP_SendMail).

  I need the calling SPs to pass their own name to the SP_SendMail as a parameter.

  I don't want to hardcode each SP's name inside it. I want a common code, something like:

  declare @CallingSPName varchar(100)

  set @CallingSPName = @@MyName

  exec SP_SendMail @Body, @To, @From, @Subject, @CallingSPName

  Is there a way I can achieve this, without actually typing the name of the SP inside it?

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  April 10, 2008 at 11:00 pm

  #801277

  select object_name(@@procid)

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537