I have a database table that contains all the server details. I have a query and wanted to run against all servers available in the table.Sample Query:
SELECT DISTINCT Col1, Col2 FROM dbo.TestRequirement
1. Connect to one server
2. Run the Query against all the user DB and save the results into a table.
Please suggest a best way to from SQL server.