As Adrian pointed out in his recent post, it is not a straightforward task to get all of the error information back to the middle tier from a stored procedure using RAISERROR. The RAISERROR statement provides three user-settable parameters: message, ...
Read post