Hi,
I need to create stored procedure to store logging information into table,
as I have one wrapper procedure which is calling 10 other procedure and hence to track which proc got failed and when and why.
I tried using
ERROR_NUMBER() ,ERROR_MESSAGE() ,ERROR_PROCEDURE() ,ERROR_STATE() ,ERROR_SEVERITY() ,ERROR_LINE()
but it is not generic
Thank you