Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger echo's
Message
 
 
To
20/09/2001 11:50:43
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Miscellaneous
Thread ID:
00558784
Message ID:
00558790
Views:
10
This message has been marked as the solution to the initial question of the thread.
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 ...
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform