MSSQL Get Current Stored Procedure Name

By admin - Last updated: Thursday, May 3, 2007 - Save & Share - One Comment

In MS SQL, the current stored procedure name can be obtained from the follow SQL snippet. It is useful for logging purposes.

— omitted code for SP.
DECLARE @Name NVARCHAR(256)
SELECT @Name = OBJECT_NAME(@@PROCID)
SELECT @Name
— omitted code for SP.
 

The value would be null if the it is not executed in stored procedure context.




Posted in Random • Tags: Top Of Page

One Response to “MSSQL Get Current Stored Procedure Name”

Comment from Jinesh
Time September 14, 2010 at 10:14 pm

Hey yup this works fine… thanks…

Write a comment


Captcha: + 1 = nine