Archive for May, 2007

MSSQL Get Current Stored Procedure Name

By admin - Last updated: Thursday, May 3, 2007

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 [...]