删除触发器: if exists ( select * from sysobjects where name = ' yourtrigger ' and type = ' TR ' ) drop trigger dbo.yourtrigger 禁用触发器: alter table [ database_name.[owner_name ] .]table_name {enable | disable } trigger [ trigger_name ]