-- Disable all triggers ALTER TABLE tablename DISABLE TRIGGER ALL ... ALTER TABLE tablename ENABLE TRIGGER ALL -- specific trigger ALTER TABLE tablename DISABLE TRIGGER triggername ... ALTER TABLE tablename ENABLE TRIGGER triggername>I have a bulk process to pull in data from old system. I need to disable triggers in two tables.
>ALTER PROCEDURE [dbo].[usp_System_LoadIncidents] >AS > >TRUNCATE TABLE tb_SafetyIncident >TRUNCATE TABLE tb_SafetyIncidentCause >TRUNCATE TABLE tb_SafetyIncidentInvolvedPerson > >-- Drop Triggers >if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SafetyIncidentNextValSP]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) >drop trigger [dbo].[SafetyIncidentNextValSP] > >if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SafetyIncidentInvolvedPersonNextValSP]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) >drop trigger [dbo].[SafetyIncidentInvolvedPersonNextValSP]