Stored Procedure Name from within stored proc 1

[ISPrincess]

I have the need to insert the name of the stored proc doing the insert into a table, but would like to make the code alittle more reusable. so rather than


Insert into mytable (ProcessName)
values('spThisStoredProcName')

I was hoping there was a way to get that from within the stored procedure (in case they change it or someone would like to copy some code from it). IE: does SQL have a command that can return that?

Insert into mytable (ProcessName)
values(@StoredProcName)


Any help would be greatly appreciated.


PH
I was walking home one night and a guy hammering on a roof called me a paranoid little weirdo.
In morse code.
-Emo Phillips

 

[vongrunt]

IIRC this is the closest shot:

select name from sysobjects where id = @@procid

 

[NoCoolHandle]

try

Insert into mytable (ProcessName)
exec StoredProcName

 

[NoCoolHandle]

sorry missread the question, ignore the answer

 

[ISPrincess]

Thank you. After checking around alittle more (sorry) i went with something similar to Vongrunt's reply:

SELECT @ProcName = Object_Name(@@ProcID)



PH
I was walking home one night and a guy hammering on a roof called me a paranoid little weirdo.
In morse code.
-Emo Phillips