Quick Reference - SQL Server
Name of the Currently Executing Stored Procedure
ΒΆ
Note: This returns NULL if executed outside the context of a stored procedure.
object_name(@@procid)