MSSQL Get Current Stored Procedure Name

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.

Continue reading about MSSQL Get Current Stored Procedure Name