Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Printing triggers
Message
De
20/02/2001 13:17:41
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00477613
Message ID:
00477695
Vues:
16
>Here's a newbie question. We have SQL Server 7.0. How do I go about printing out the code for a trigger on a table? So far, all we can figure out to do is print screens!

Marie,

You can go in the Query Analyser and use the sp_helptext stored procedure:
sp_helptext '<i>trigger name</i>'
Then print it from there, or copy to another application (such as Word) to print it from there.

Hope this helps!
Sylvain Demers
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform