Multi server Query


I am running multi-server query(same query is running on all the server) and result is comman with different value, now i want to store its result in the comman place(like in a table) on a local server, please help

One option would be use SSIS.

For a one time process - if you are running this in SSMS using a multi-server query. Modify the output to a file (either comma or tab delimited) - run the query - then use the import wizard to import the file into a single database/table.

If you want a repeatable process - then SSIS would be the better option. You could even have it data driven in a for-each loop to modify the connection on each loop and process for each server/database.

how many servers?

4 servers