I'm looking for a tool to autogenerate sql server documentation

Posted on 2005-03-03
Medium Priority
Last Modified: 2008-03-04
Does anyone know where I can download a tool wich is able to generate documentation from a sql server installation.  The tool should be able to:
Give me a report which shows the time for last full backup and last log backup for all the databases on the server.  
Give me a report of all the users pr database.
Give me a report of all the db and log files pr database on the server.
Give me a report of all the jobs on the server and when they are sceduled to run next time.

I hope you understand what I mean.  I do not want to buy a complex and expensive administration tool, but only a simple reporting tool that fetch data from the different system tables og information_chema views.

Question by:olebrum030800
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 23

Expert Comment

ID: 13448029
I do not know of one, but this would be easy enough to write a custom one. Would also be interested to know if there is one so I'm listening....
LVL 43

Accepted Solution

Eugene Z earned 750 total points
ID: 13448238
use T-Sql of MS SQL SERVER - with e.g.
with MS SQL Reporting Service, Crystal Reports, .Net, etc,etc,etc..

 there are a lot of system stored procedures and tables with all data that you need :
for example run in Query Analyzer (QA):
>Give me a report of all the users pr database.
exec sp_helpuser

>Give me a report of all the db and log files pr database on the server.
exec sp_msforeachdb "select '?' as dbname, name [LogicalName],filename from ?..sysfiles"

>Give me a report of all the jobs on the server and when they are sceduled to run next time.
exec msdb.dbo.sp_help_job

Expert Comment

ID: 13450135
look at idera sqlcheck (http://www.idera.com/Products/SQLcheck/Default.aspx), it offers a nice interface for sql server diagnostics and a couple of reports.
It won't do everything you like, but hey it's free and does things you didn't mention.

I'm not so sure you'll find a cheap tool that does exactly what you want (I don't know of any) but it's not all that hard to use a few stored procedures and selects in system tables to get what you want.
You could xp_sendmail it to yourself and get a plaintext report or use reporting serivices or crystal reports for nicer looking reports
LVL 43

Expert Comment

by:Eugene Z
ID: 13458685
just curious:
why grade B -
we help for free - it is already by default - Grade A

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question