Home Forums Article Discussions Article Discussions by Author Discuss content posted by Pinal Dave Disable All Triggers RE: Disable All Triggers
Richard M.
SSCertifiable
Points: 7401
More actions
July 1, 2010 at 7:39 am
#1187661
Good question and use of the undocumented sp_MSforeachdb.
Now, I have a remark here, the question stated "...disable all triggers in a database".
As Hrvoje noted above, Database scoped triggers as well as triggers on views would not be disabled.
_______________________________________________________________________For better assistance in answering your questions, click here[/url]