Home Forums SQL Server 2008 SQL Server Newbies Run a query against registered servers and insert results into table RE: Run a query against registered servers and insert results into table

  • stebennettsjb (3/2/2012)


    Hi all,

    Is it possible to run a query against multiple registered servers and have the results inserted into a table?

    Trying to get details of SQL boxes and wanted to keep the data dynamic and always up to date.

    So id like to run say

    SELECT @@VERSION AS [SQL Server and OS Version Info];

    Thanks

    S

    Have you tried SSIS? It is a good tool to perform these kind of tasks.


    Sujeet Singh