Hi,
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
Hi,
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