You can get a list of all the triggers in the database by following command in Query Analyzer.

select name from sysobjects where type = 'tr'

you can view the code of a trigger with following command

sp_helptext 'triggername'