I'm looking for a tool to autogenerate sql server documentation
Posted on 2005-03-03
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.