Hello,
I am trying to log down all errors happened in a batch job/SP. For example the error message : Cannot insert the value NULL into column 'PO_ID', table 'Training.dbo.PO'. I can easily refer this system message from the sysmessage table by the error code returned . However, the macro inside the message, like the column 'PO_ID' or 'Training.dbo.PO', are not available there. How can I get these macro as well?
Thanks
I am trying to log down all errors happened in a batch job/SP. For example the error message : Cannot insert the value NULL into column 'PO_ID', table 'Training.dbo.PO'. I can easily refer this system message from the sysmessage table by the error code returned . However, the macro inside the message, like the column 'PO_ID' or 'Training.dbo.PO', are not available there. How can I get these macro as well?
Thanks