SQL Server Performance Forum – Threads Archive
Error Handling, how to catch before user sees them
I would like to capture any error messages while generating a report and fail gracefully. Is there any way to do this? I am attempting to capture stored proc errors as well as invalid data passed to the report. An example would be if I was searching on a name of a project and that project was invalid. Instead of typing in the XXXXXX format they typed in XXX-XXX which would generate an error. How can I best catch this? I am working in RS 2000 right now with no plans at the moment to go to 2005. thanks mikeAs far as I know, custom error handling is not possible. RS displays its own Error message as "#Error". Thanks, Bijesh
]]>