-- disable all triggers Sql
EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL"
-- Enable all triggers Sql
EXEC sp_MSforeachtable @command1="ALTER TABLE ? ENABLE TRIGGER ALL"
-- Disable single table and single trigger
ALTER TABLE DemoTrg DISABLE TRIGGER utrDemo
-- Enable single table and single trigger
ALTER TABLE DemoTrg ENABLE TRIGGER utrDemo
No comments:
Post a Comment