--------------------显示所有触发器--------------------------select substring(s2.Name,1,30) as [Table], substring(s.Name,1,30) as [Trigger], case(select objectproperty(object_id(s.Name),'ExecIsTriggerDisabled')) when 0 then 'Enabled' when 1 then 'Disabled' end as Status from sysobjects s join sysobjects s2 on s.parent_obj=s2.id where s.type='TR' order by [Table],[Trigger]检查一下
skyboy0720(http://www.xisuo.com/) 提醒的是
update jf_phone set yhdz='sdf' where phone='812' //这一句是对的.你一定是用了触发器 update ,触发器就有操作fw_status这张表,由于库中根本就没有'fw_status'这张表,只有'fw_statuse'表所以出现的.仔细检查一下: select name from sysobjects where type='tr'
substring(s.Name,1,30) as [Trigger],
case(select objectproperty(object_id(s.Name),'ExecIsTriggerDisabled'))
when 0 then 'Enabled'
when 1 then 'Disabled'
end as Status
from sysobjects s
join sysobjects s2
on s.parent_obj=s2.id
where s.type='TR'
order by [Table],[Trigger]检查一下
select name from sysobjects where type='tr'
'fw_statuse'与'fw_status'