Error Handling, how to catch before user sees them | SQL Server Performance Forums

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 mike
As far as I know, custom error handling is not possible. RS displays its own Error message as "#Error". Thanks, Bijesh
]]>