a table in 10 DBs in multiple instances, I need to union all the select from this table RRS feed

  • Question

  • Hi Experts,

    I have a table that has a list of the Databases in 5 instances. The five instances are linked servers. The table has same everything (structure)in all the DBs. I have to select from this table from one location so that I can have a statistics of each database.

    Any ideas?


    Thursday, April 17, 2014 9:11 PM