>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