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

Question

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

0

eddiegroves Dec 11. '08 at 2:28

1 answer

Tautologistics · Accepted Answer · 2008-12-11T02:46:22+0000

Try the following:

OBJECT_NAME(@@PROCID)