Post reply

Capture multi-server query results to table

  • October 5, 2010 at 8:38 am

    #229119

    Hi I would like to capture the results of queries ran on multiple servers through a central management server but because the queries are run on the remote systems, I can't figure out how to insert the results into a single table on one server.

    Is this possible without setting up a linked server on all of the remote servers and inserting the results one at a time?

    Thanks much.

    Howard

  • October 7, 2010 at 4:44 am

    #1233398

    I don't think it can be done.

    When you run a query in multi-server mode, the query is run on each connected server and the results are merged by SSMS.

    Issuing SELECT INTO would create a separate table on each server.

    -- Gianluca Sartori

  • October 7, 2010 at 8:26 am

    #1233621

    Thanks, that is the conclusion that I reached too.

    There is some way to do it though because Enterprise Policy Management Framework manages to capture cms output to a database. I think it uses PowerShell.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply