SQL: Custom SQL Info/Config Report - Printer Ready! v1.7
Author: jason
Date: 2016-05-04 12:43:37
Category: Technical

Here is an updated printable report for SQL Information and Configuration! I've tested the report queries against SQL 2005 SP4, SQL 2008 R2, and SQL 2012, and now with SQL 2014. It looks great. The best part is this report is rendered from within SQL Studio Management itself, a reporting server isn't needed. I used Visual Studio 2005 to create the report.

Here is the updated report RDL for you to use (Right-Click the link and choose Save Link As).
This report encompasses all the configuration items, plus some more, from my previous article and previous article.

Updated in version 1.7 is a TOP 10 Stored Procedures



To run this report directly in Studio Management:
1. Download the linked RDL to your desktop
2. Open SQL Studio Management
3. Connect to a SQL Server
4. Right-click the server
5. Choose Reports
6. Choose Custom Reports…
7. Browse to the RDL and Select it
8. To Export as PDF, right click inside the report window and choose Export…

If you are nervous about using the RDL, open it with Notepad and review the queries.



jason @ jasonthomasfrance.com - www.masterstationlog.com - copyright 2009