SQL List all Triggers
SELECT
'DISABLE TRIGGER ' + SYSOBJECTS.name + ' ON ' + OBJECT_NAME(parent_obj) + ';' as DisableScript,
'ENABLE TRIGGER ' + SYSOBJECTS.name + ' ON ' + OBJECT_NAME(parent_obj) + ';' as EnableScript,
sysobjects.name AS trigger_name
,USER_NAME(sysobjects.uid) AS trigger_owner
,s.name AS table_schema
,OBJECT_NAME(parent_obj) AS table_name
,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate
,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete
,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert
,OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS isafter
,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isinsteadof
,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]
FROM sysobjects
INNER JOIN sysusers
ON sysobjects.uid = sysusers.uid
INNER JOIN sys.tables t
ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s
ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'
-- AND sysobjects.name not like '%trg_modified' --excludes Evolution modified triggers
-- AND sysobjects.name not like '%_trg_audit' --excludes Evolution Audit triggers
--and OBJECT_NAME(parent_obj) IN ('_btblInvoiceLines','InvNum','PostST','PostAR','PostGL') --for specific table triggers.
ORDER BY OBJECT_NAME(parent_obj)