--查询触发器的禁用/启用状态select 表名=object_name(parent_obj),触发器名=name
,状态=case status & power(2,11) when power(2,11) then '禁用' else '启用' end
from sysobjects
where type='TR'
,状态=case status & power(2,11) when power(2,11) then '禁用' else '启用' end
from sysobjects
where type='TR'
,状态=case status & power(2,11) when power(2,11) then '禁用' else '启用' end
from sysobjects
where type='TR' and name='触发器名' --这里加上你要查看的触发器名
select name from sysobjects where xtype='TR' and (status/2048)%1024=1
启用的触发器:
select name from sysobjects where xtype='TR' and (status/2048)%1024=0
--status的第11位为标识
另外,请问这里的status有什么意义?