Unanswered: Capture Error Description in Stored Proc
I am executing a stored procedure. Once statement is raising error (No. 515). While executing the procedure it is showing the proper error description as below:
"Cannot insert the value NULL into column 'actual_activities', table 'NBS.dbo.JOB_MASTER'; column does not allow nulls. UPDATE fails."
But when I am trying to get the message from "MASTER.DBO.SYSMESSAGES" for the ERROR number = 515 I am getting the following message:
"Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails."
Can you please let me know how to get the actual message?