SELECT
sysobjects.name AS TriggerName,
OBJECT_NAME(parent_obj) AS TableName,
OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS UpdateTrigger,
OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS DeleteTrigger,
OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS InsertTrigger,
OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS AfterTrigger,
OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS InsteadOfTrigger
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
OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') <> '1'
