SQL: Custom SQL Info/Config Report - Printer Ready! v1.5
Author: jason
Date: 2014-05-02 20:03:16
Category: Technical

Introducing a new printable SQL Information and Configuration Report! I've tested the report queries against SQL 2005 SP4, SQL 2008 R2, and SQL 2012. It looks great. The best part is this report is rendered from within SQL Studio Management itself, a reporting server isn't needed. I had to use Visual Studio 2005 to create the report.

Here is an example PDF of the report.
Here is the 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.

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