Thursday, 13 March 2014

Disable/Enable all trigger in a database

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

To Enable All the Triggers
sp_MSforeachtable "ALTER TABLE ? ENABLE TRIGGER ALL"

1 comments:

Microsoft Technology said...

very informative

4 June 2014 at 02:51

Post a Comment

Subscribe to: Post Comments (Atom)