How to grab the triggers from a SQL Server database

Have you ever needed to get the script that created a trigger on a table in a SQL Server database?

Try this:

select b.text
from sysobjects a
join syscomments b on a.id=b.id
where xtype='TR'

Hope that helps.