michaelberry67 (4/22/2009)

---

...you got me very interested. Looking forward to you finishing this article and wish you all the best in completing it. I was about to start something like this (I have modified SP2 reports to work on all servers but it wont work on SQL 2008. Will this?)

jhadden (4/22/2009)

---

I remain confused by the purpose of this project. SQL Server 2008 provides Centralized Management Server which allows you to register all of your servers in a single location and execute a single command against all of them from one location. This is all built into the product. At a minimum, shouldn't this be the mechanism used to gather your data rather than creating a server table and looping through it to execute DML commands.

http://msdn.microsoft.com/en-us/library/bb934126.aspx

There are also mechanisms for data collector, which will gather data and place it into a "management data warehouse".

http://msdn.microsoft.com/en-us/library/bb677248.aspx

Seems like you're re-inventing a more cumbersome wheel here.