In SQL Server 2005 SP2 (and of course in SQL Server 2008) you can create your own custom reports that will show in SQL Server Management Studio. We’ve seen great adoption of this process, and it can really make Management Studio a one-stop-shop for showing server activity.
Pam, a friend of mine from Florida, asked me to help debug a report that she had migrated from one server to another. This is always a tricky business, since the variables, tables, connections and so on that exist on one server might not exist on another. I pointed out some resources that would help, and she sent me a link to a very useful tool:
I think you might find it useful, too. Thanks Pam!
Take advantage of special member promotions, everyday discounts, quick access to saved content, and more! Join Today.