• 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]