Reply To: How to enable and disable trigger in SQL server

Andrew Jackson ~ Modified: December 19th, 2015 ~ ~ 1 Minute Reading

December 19, 2015 at 12:17 pm #1005 Score: 0

Moderator

Karma: 1 pt

To disable / enable selective triggers…

ALTER TABLE tableName DISABLE TRIGGER triggername
ALTER TABLE tableName ENABLE TRIGGER triggername

To disable / enable all triggers…

ALTER TABLE tableName DISABLE TRIGGER ALL
ALTER TABLE tableName ENABLE TRIGGER ALL