How to get triggers in database?

Use the following SQL to get list of all triggers in database:

select tbl = object_name(parent_obj), "trigger" = name FROM sysobjects
where type = 'TR' order by tbl