Raising Error in MS SQL Triggers

Hi Guys,

I have been facing an issue in MS Sql Triggers while executing Raiserror Statements. Raiserror statment works absolutely fine in normal cases. But when the same is written after any statment returning rowset (eg. select * from employee) then this Raiserror statment returns me the Error specified in the statment when done in Query Analyser but not in frontend. I need to capture the same error in frontend using Visual Basic and ADO. Is there any way I can blank out rowset.

Please Help me get out of this critical issue.


Awaiting for early response.


Regards and best wishes,
Sufiyan