Every once in a while, we perform upgrades and updates to one of the main applications we use company wide, and when we do, it drops all our custom triggers. Why, I'm not sure, but it does. It's a little annoying when the developers don't have backups of the triggers they've created, so here's something I run to get all the triggers in a database. Just set Management Studio to save the results to a file and then press F5.
SELECT OBJECT_NAME(asm.object_id) ,asm.[definition] FROM sys.all_sql_modules asm WHERE asm.object_id IN (SELECT object_id FROM sys.events)
Yes, that's all it is. Comment out the first column (and comma) if you don't want the name of the trigger.