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

For 2005 and 2008 you can use the OBJECT_DEFINITION() function

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.