• 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