jayu p

jayu p

  • 2k
  • 60
  • 1.4k

Generic stored procedures logging functionality

Nov 1 2021 8:16 AM

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


Answers (2)