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