Dynamically Getting Stored Proc Name

• yaweah

  Default port

  Points: 1489

  More actions

  December 29, 2003 at 4:04 pm

  #85206

  I have a quick question and I am hoping the MVP's and Expect will help me here.

  I am hoping T-SQL have a function that will allow you to get the name of a stored procedure while the code within the procedure is running.

  what I mean is having a procedure name "A", to call this procedure you must know the name of it (that given) now after calling the procedure, I want to dynamically retrieve the name of the procedure ("A") without hard coding it so that when the procedure name changes, I will not have to go in the code and change lines of code.

  Is this possible? if it is how it is done? Any sample code available? HELP.

  Thanks.

• wz700

  SSCertifiable

  Points: 7133

  More actions

  December 29, 2003 at 5:29 pm

  #488094

  create proc spname as

  select object_name(@@PROCID) procname

  go

  exec spname