Hi
I'm writing triggers to audit changes made by users through our application that we develop. When something goes wrong in the trigger I do not want the trigger to throw back the error to the application, instead I want to log the occured error in a file or database table.
Does anyone have any tip for me? The important thing is that the error is not reported back to the application because then a "ugly" message is shown to the user who will get confused and our support will get unnessicary much job to do.
I am kind of new to SQL Server, and would be greatful for any tip.
Regards Maria
I'm writing triggers to audit changes made by users through our application that we develop. When something goes wrong in the trigger I do not want the trigger to throw back the error to the application, instead I want to log the occured error in a file or database table.
Does anyone have any tip for me? The important thing is that the error is not reported back to the application because then a "ugly" message is shown to the user who will get confused and our support will get unnessicary much job to do.
I am kind of new to SQL Server, and would be greatful for any tip.
Regards Maria