You can do it using
CREATE PROCEDURE dbo.TEST
AS
DECLARE @ProcName sysname
SET @ProcName= OBJECT_NAME(@@PROCID)
Print @ProcName
GO
This will print the name "TEST".
_________________________________________________________________________
SSC Guide to Posting and Best Practices