>Add
SET NOCOUNT ON
at the begginning of the trigger.
>
>>I've written a trigger which updates several tables. The trigger runs fine and when I launch in the query analyzer, I get x times (1 rows updated) in the messagewndow.
>>
>>I was wondering, do I have to suppress these messages to prevent them to go over the network back to the client, and if yes how ? As I use VFP to run the update that activates the trigger, I don't need those messages as VFP can't handle them anyway ...
Thanks for the fast solution !!
Is it correct as I suppose that these messages go over the network, even if they aren't used at the other side, or does this only play when using for example query analyzer ?