• If you have SQL Servers list in the database you may run a query that will get a servername from the database, append strings before and after and output in the results window a set of statements like this:

    SELECT * FROM OPENROWSET('SQLOLEDB','Provider=SQLOLEDB;Server=MyServerName123;Trusted_Connection=yes','select @@servername, <put here everything you want to select according to postings above')

    Then copy the output from the results window to the query window and run. It will dynamically connect to all servers without actually having linked servers set up and return results for them if your domain account have rights on all servers. if the connection fails for 1 server it will still get other servers.


    Regards,Yelena Varsha