In a stored procedure, how can I get the name of the sproc in SQL Server 2005?

Question

I want to dynamically get the name of the current stored procedure inside itself for logging purposes.

Answer 1

Try this:

OBJECT_NAME(@@PROCID)

Answer 2

Thanks very usefull for debugging !!!