Handling Stored Procedure Exception

You can't technically throw an exception from a stored proc. You candle them *in* the stored proc and return some sort of an error message back to the calling front end (through the SqlCommand.Parameters property).

If you don't handle the exceptions in the stored proc itself, the framework will throw database-related exceptions that you can handle in the front end-code.

Where you handle the exception is dependent on what your code is doing. If you want to be able to rollback a transaction, you could do it in either the stored proc or the front-end, but again, that depends on how you're performing transactions.

Hi
Inside the store procedure use beging catch to catch the exception as shown below which will return you the error number, errormessage, error line....

BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() AS ErrorState,
ERROR_PROCEDURE() AS ErrorProcedure,
ERROR_LINE() AS ErrorLine,
ERROR_MESSAGE() AS ErrorMessage;
END CATCH

hope this will help you. :)