Sending a warning to the user from SQL server?

[garwain]

I have several triggers in my database used to validate data, and by using the RAISERROR procedure, I can send an error message and abort the procedure in my program at the same time. Is there any way I can send a warning that will give the user a popup, but not halt processing. or rollback the transaction?

thanks.

 

[LucieLastic]

Would something like this help at all?
eg

TRY
startTransaction;
:
TRY
//error occurs in here somewhere
EXCEPT
MessageDlg('warning msg'...)
END;
FINALLY
CommitChanges etc
END;