Determine sproc name within the spoc itself 2

[buddafish]

All -

I would like to be able to determine the stored procedure name from within the procedure itself. Kind of like what I do with the database name:

SELECT @DB_NAME = db_name()

Anybody know a way to get the procedure name? Ideas?

Thanks in advance -
Scottie

 

[RiverGuy]

I don't know of a way, but if I had this as a requirement, I would just hard code the name to a variable inside the stored procedure.

 

[jbenson001]

SELECT object_name(@@PROCID)

 

[RiverGuy]

Awesome!

 

[jbenson001]

 

[buddafish]

well, that appears like the perfect answer, yet for me, i return null for the object_name. select * from sys.procedures shows the sproc by name and object_id, but the object_id <> @@procid. ??

thanks for the reply. i will keep kicking it around.

 

[jbenson001]

You have to use that within the stored procedure. If you run that on it's own, then yes, you will get a NULL.

 

[buddafish]

doh!

thanks again!

 

[jbenson001]

No problem, glad to help.