Go right ahead, Gary -- your thank you is enough!

I'd also look back over the comments. MaricopaJoe has made some significant additions to his version of these reports and...

Great - thanks for the info!!!

I don't know - we're just getting ready to go to 2012 soon (and when I do, you can bet these will be one of the first things I check...

Thanks. That makes sense. I just read something else that states while you may have multiple database instances (of different versions) on a server, you can only have...

The (Windows) server itself is 2008, but it is running SQL Server 2005.

Awesome stuff James!!!

This is a really great find and is in many ways a holy-grail find for what we've been trying to do!!!

thanks jcoe - i'll have to take a look at the data source as that is something in particular we're looking to include. the problem we have encountered is...

Thanks for the collaboration Jcoe - I put that query in the report - works great.

joe...

sorry for the delay - been working on a large project deployment. anyway, i updated the command text report to display multiple queries (should the report have more than...

Thanks -- the query you mention does have a limitation as it looks for the first instance of "<CommandText>" and "</CommandText>" to use as start and end locations -- but...

No problem - I'll notify you directly (with another reply) when this is done.

That is something I stated it does (display the first query used). Eventually I'll build a section (probably using a CTE) to concatenate all of the queries together.

My guess is that one of the reports on the server getting the error has a query that is causing the problem. This is something I would like to...

Verify the name of the report (probably case sensative). I just downloaded the pack and placed the reports in a new reporting project and they appear fine. I...

Thanks Steve!!!