Names of the following ServerName, DatabaseName & ObjectName (sproc)

[SteveMe]

How do I determine the Stored procedure name?

I know how to find the
ServerName -- @@ServerName
Database -- db_name()
Object(Stored Procedure) -- ?????

This code would run in a Stored Procedure.
Thanks in advance

 

[vongrunt]

OBJECT_NAME(@@PROCID) ?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SteveMe]

What if its the current Sproc and you don't know the associated ID or how can you get the current sproc associated ID?

 

[vongrunt]

Run this:

create procedure blahproc
as
	select @@PROCID, object_name(@@PROCID)
go

exec blahproc
drop proc blahproc

Does @@PROCID stuff work as expected?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SteveMe]

Thanks u rock