sqlserver 中查看trigger的disabled/enabled情况

SELECT
    t.name  AS TableName,
    tr.name AS TriggerName,
    CASE
        WHEN 1=OBJECTPROPERTY(tr.id, 'ExecIsTriggerDisabled')
        THEN 'Disabled'
        ELSE 'Enabled'
    END Status
FROM
    sysobjects t
INNER JOIN
    sysobjects tr
ON
    t.id = tr.parent_obj
WHERE
    (
        t.xtype = 'U'
    OR  t.XType = 'V')
AND (
        tr.xtype = 'TR')
ORDER BY
    t.name,
    tr.name

alter table TableNameenable trigger TriggerName