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

  • There are a couple of options how you can do this and the best choice will probably depend on what exactly you try to achieve.

    With SQL 2008 you have the option of creating a central management server and the run a query from that server on all registered servers or a group of servers.

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-Central-Management-Servers-have-you-seen-these.aspx

    Other options would be using linked servers or powershell.

    [font="Verdana"]Markus Bohse[/font]