• I would be careful about using the stored proc - sp_MSforeachdb.

    1. it uses global cursors to do its work in sp_MSforeach_worker.

    2. it really has no error handling

    So it may be a nice quick and dirty tool to use when manually doing stuff. But when set into an automated process you may be asking for trouble.