How can I get the definition (body) of a trigger in SQL Server?

sp_helptext works to get the sql that makes up a trigger.

The text column in the syscomments view also contains the sql used for object creation.