SSRS Catalog Queries SSMS Project (11-30-2011)

Rating: No reviews yet
Downloads: 60
Change Set: 4635
Released: Nov 30, 2011
Updated: Dec 17, 2011 by BStateham
Dev status: Alpha Help Icon

Recommended Download

Source Code SSRS Report Queries
source code, 16K, uploaded Nov 30, 2011 - 60 downloads

Release Notes

SSRS Catalog Queries SSMS Project (11-30-2011) Release Notes

This is the initial release of my SQL Server Reporting Services (SSRS) Catalog Queries SSMS Project. You can open this project in SSMS 2008 R2. If you are using an older version of SQL Server Management Studio, you should be able to open the script files (.sql) directly, just not the project or solution. I will attempt to include separate 2005, 2008, and 2008 R2 versions in the future.

Release Contents

This release includes the following scripts:
  • "01 - Create the ReportQueries database.sql"
  • "02 - Query Catalog Content.sql"
  • "03 - Create the CatalogContent View.sql"
  • "04 - Find all Data Set Commands.sql"
  • "05 - Find all the Data Set Fields.sql"
  • "06 - Determine Fields Actually Used.sql"
  • "07 - Find all Connection Strings.sql"
  • "08 - Extract Connection String Components.sql"


These queries are presented for educational and demonstration purposes only. I do not recommend running these in production code as they are unsupported by Micorosft, and some have high performance costs. Use these at your own risk.

Reviews for this release

No reviews yet for this release.