I'm trying to add error reporting to a stored procedure, using RAISEERROR. Ideally I want ADO to report it in the same way as if it was bad sql (ie, back in the client app ADO raises an exception, which can then be handled). However, using raise_error is not causing this behavoir. In query analyser, my error message is simply printed, but not in red like other system errors. I think this indicates the difference. RAISERROR('Manufacturer does not exist', 1, 2) WITH SETERROR Any advice please ?