Retrieving stored procedures name..

[MarkButler]

I wish to create a log when scheduled procedures are run to capture some counts and totals. I want to insert a record into a log file each time the procedure is run. I wish to store the name of the stored procedure to this log file. What I am looking for is a way to determine from within the stored procedure its name.

I am looking for a function similar to the "DB_Name" function. I found the "@@ProcID" which returns an integer but how do I get from that to the name of the actual procedure or is there a function I am missing?

TIA
Mark

 

[rsinj]

use it as an index into sysprocedures

 

[rsinj]

sorry, sysprocedures won't give you the name - use it against sysobjects and look at the name field in sysobjects:

select name
from sysobjects
where Id = @@ProcId

 

[rsinj]

one last shot - @@ProcId won't be enough when querying sysobjects:

select name
from sysobjects
where Id = @@ProcId
and xtype = 'P'

 

[MarkButler]

Worked like a champ, thanx