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
Using @@PROCID with OBJECT_SCHEMA_NAME
How to use @@PROCID to always return the correct name of the procedure
What happens when you use @@PROCID inside of a trigger
