Sunday, February 21, 2016

How to disable all triggers MS SQL Server

To disable all trigger

sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER all'

Or to enable or triggers

sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER all'
Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)