list all triggers on sql server database

1SELECT  
2    name,
3    is_instead_of_trigger
4FROM 
5    sys.triggers  
6WHERE 
7    type = 'TR';

1SELECT 
2     sysobjects.name AS trigger_name 
3    ,USER_NAME(sysobjects.uid) AS trigger_owner 
4    ,s.name AS table_schema 
5    ,OBJECT_NAME(parent_obj) AS table_name 
6    ,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate 
7    ,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete 
8    ,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert 
9    ,OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS isafter 
10    ,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isinsteadof 
11    ,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled] 
12FROM sysobjects 
13
14INNER JOIN sysusers 
15    ON sysobjects.uid = sysusers.uid 
16
17INNER JOIN sys.tables t 
18    ON sysobjects.parent_obj = t.object_id 
19
20INNER JOIN sys.schemas s 
21    ON t.schema_id = s.schema_id 
22
23WHERE sysobjects.type = 'TR'