禁用触发器:
alter table tb disable trigger tir_name
启用触发器:
ALTER TABLE DATABASEName enable trigger tir_name
修改数据库兼容模式:
ALTER DATABASE DataBaseName
SET COMPATIBILITY_LEVEL = 120; --(80=2000,100=2005......)
禁用触发器:
alter table tb disable trigger tir_name
启用触发器:
ALTER TABLE DATABASEName enable trigger tir_name
修改数据库兼容模式:
ALTER DATABASE DataBaseName
SET COMPATIBILITY_LEVEL = 120; --(80=2000,100=2005......)