Thursday, 13 March 2014

Disable/Enable all trigger in a database

Posted by Sanjeet Kumar Satpathy at 10:14 Labels: 1 comments
To Disable All the Triggers
sp_MSforeachtable "ALTER TABLE ? DISABLE TRIGGER ALL"

To Enable All the Triggers
sp_MSforeachtable "ALTER TABLE ? ENABLE TRIGGER ALL"
Subscribe to: Posts (Atom)