Blogging is pretty new for me and it’s difficult to know how interesting or valuable my stuff is. So I am pleased that my thoughts on providing a way to get the standard SQL server reports to run across multiple servers have generated some interest.
I would agree that what I wrote was a lash up that is only really appropriate for a few servers and is quite labour intensive. For the big enterprise there is System Center which can do this kind of thing, but not everyone is going to make that investment.
One of my new friends, Buck Woody in the SQL server product team has quite a few posts on this subject on his blog and he also sent me a link where the report definitions (RDL) for the standard reports can be found so you won’t need to use profiler to trap the SQL used.
That’s why I blog, to learn and pass it on.