Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger echo's
Message
 
 
À
20/09/2001 11:50:43
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Divers
Thread ID:
00558784
Message ID:
00558790
Vues:
12
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform