>How do you catch the return values of Raiseerror and Print in the client application?
ODBC or OLEDB should pass the error information from RAISERROR to the client. I have no idea how PRINT will be handled but if you use SELECT instead of PRINT (ie SELECT 'this is my message') the message will be returned as a result set.
-Mike