Home Forums SQL Server 2008 T-SQL (SS2K8) Getting an object name from within it's own code RE: Getting an object name from within it's own code

  • October 9, 2015 at 2:27 pm

    #1832671

    @@PROCID

    Returns the object identifier (ID) of the current Transact-SQL module. A Transact-SQL module can be a stored procedure, user-defined function, or trigger.

    https://msdn.microsoft.com/en-us/library/ms174408(v=sql.105).aspx

    So this should work:

    object_name( @@procid )

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho