SQL Server Video to return the procedure name using @@PROCID

By:   |   Updated: 2014-07-14   |   Comments   |   Related: More > Stored Procedures


Enter your business email address to
get free SQL Server tips.

Problem / Solution

The input parameter @@PROCID returns the object_id of the current stored procedure, function or trigger. This video shows how to use @@PROCID in a stored procedure to get the schema and procedure name. It also corrects a misperception that appears in some places on the internet that @@PROCID would let you know which procedure initiated a trigger. It doesn't do that and that problem is demonstrated.

Key Learning Items
  • Using @@PROCID with OBJECT_NAME
  • How to use @@PROCID to always return the correct name of the procedure
  • What happens when you use @@PROCID inside of a trigger
Read Companion Tip
Click Here

Last Updated: 2014-07-14

get scripts

next tip button

About the author
MSSQLTips author Andy Novick Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience.

View all my tips

Comments For This Article


Recommended Reading

Using Parameters for SQL Server Queries and Stored Procedures

Several Methods to collect SQL Server Stored Procedure Execution History

SQL Server Stored Procedure Input Parameter, Output Parameter and Return Value

Save SQL Server Stored Procedure Results to Table

Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

get free sql tips
agree to terms