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

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |