how to catch custom errors raised in SP gracefully?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Bob (bobatkpmg_at_yahoo.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 12:44:21 -0500

In my stored procedure, I raise an error using RAISERROR. Seems it just
comes out to the .NET code as a SqlException. Is there a way to
differentiate my custom error from the raw SqlExceptions (like table is
missing, FK violation etc), because if I purposely raise an error, I sure
want to handle it differently.

Thanks
Bob

Relevant Pages