I have 1 wrapper procedure which is calling 10 other stored proc to import data, and I need to log into table if any of the proc from wrapper get failed - to insert objectId of that procedurce
@@procId is not helping, as it is writing the proc which I am executing, but not the one which got failed from previous proc execution
I do not have to hard code name
Thank you