Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger echo's
Message
From
20/09/2001 12:08:56
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Miscellaneous
Thread ID:
00558784
Message ID:
00558801
Views:
16
>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 ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform