How to get name of the executing script

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399338 More actions · Answer 1

SELECT OBJECT_NAME(@@PROCID);

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

zeusthrax Grasshopper Points: 17 More actions · Answer 2

Grasshopper

Points: 17

July 7, 2008 at 12:44 pm

That just give me NULL

Grant Fritchey SSC Guru Points: 399338 More actions · Answer 3

It depends on the context that it's running under. If you're running it in a query window, it probably will return NULL.

Try this:

CREATE PROCEDURE ProcName

AS

SELECT OBJECT_NAME(@@PROCID);

GO

EXEC [ProcName];

You should see 'ProcName' in the result set.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt