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?)
Thanks Michael. Yeh, it should work on 2008 fine.
No, we don't have any 2008 servers, just 2000 and 2005.
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.
http://www.sqlservercentral.com/Forums/FindPost700958.aspx
I'm fairly confident that down the line, you'll hit a snag when trying to write a particular report using the CMS. It just won't be as flexible as writing your own programme. If you're limited to time, then fair enough, if not, then why not get creative? 🙂