sqlserver 中查看trigger的disabled/enabled情况

发布时间：2020-12-12 13:13:02 所属栏目：MsSql教程来源：网络整理

导读：SELECT t.name AS TableName,tr.name AS TriggerName,CASE WHEN 1=OBJECTPROPERTY(tr.id,'ExecIsTriggerDisabled') THEN 'Disabled' ELSE 'Enabled' END StatusFROM sysobjects tINNER JOIN sysobjects trON t.id = tr.parent_objWHERE ( t.xtype = 'U' OR t

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 TableName enable trigger TriggerName
?alter table TableName?enable trigger TriggerName

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!