How can you get current stored procedure name via T-SQL?

by Joe Hunter 29. September 2010 17:56

SELECT OBJECT_NAME(@@PROCID)

Using T-SQL to get database nameIf you need to get the database name in T-SQL sproc: select db_name()Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servernameT-SQL function to return name of log file for a database ALTER FUNCTION [dbo].[UDF_DB_LOG_FILE_NAME] ( &...