Eddie Groves
Eddie Groves

Reputation: 34848

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

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

Upvotes: 0

Views: 144

Answers (1)

Tautologistics
Tautologistics

Reputation: 1508

Try this:

OBJECT_NAME(@@PROCID)

Upvotes: 3

Related Questions