SQL Server: How to get a Stored Procedure name in CATCH Block

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing a small and useful demonstration for printing a Stored Procedure name in the CATCH block of SQL Server.

SQL Server developers are using TRY CATCH block in their Stored Procedures, but if they print Stored Procedure name in the CATCH block, it is easy to identify a particular stored procedure error from the error log files.

It is also beneficial for an application developer to determine the name of the stored procedure with an error.
We can use ERROR_PROCEDURE() to print a stored procedure name in the CATCH block.

Below is a small demonstration on this:

Create a sample stored procedure:

Execute above sample stored procedure: