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.