Home Forums SQL Server 2016 SQL Server 2016 - Administration how to deploy 10 T-SQL scripts across 200 databases RE: how to deploy 10 T-SQL scripts across 200 databases

  • August 18, 2017 at 1:22 am

    #1955764

    Jeff Moden - Wednesday, August 2, 2017 8:08 PM

    Again, I agree that CMS is fine for administering multiple servers but this problem (according to the original post) has nothing to do with multiple servers.  It has to do with running 10 scripts across 200 databases on the same server.  How does CMS help you in that area?

    Hi
    You could always register each database in you registered servers list, using the Default Database option.
    This is something we practice for running quick MI across multiple client databases hosted on the same server.

    Cheers
    Steve.