Folks,

Does anybody know of any free tool that I can use to create documentation for all the stored procedures and table in SQL 2005?

Thanks,

John

What kind of documentation are you after? I have a script that creates a webpage html file for an entire database using tables. I use it to provide a data dictionary to new developers.

A google search brings back the following:

http://www.codeproject.com/KB/database/sqldoc.aspx

http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx

http://weblogs.asp.net/jgalloway/archive/2006/09/28/_5B00_Tool_5D00_-Data-Dictionary-Creator-_2D00_-Rapidly-database-documentation.aspx

These are roughly similar to what I have. I needed a specific format, so I wrote my own, but recall doing searching for this a few years back, and there are a number of good tools out there for free.

Hi,

Generating Tables information is very easy, its just that you need to know the system tables which stores the columns & their properties like Not Null or DataType etc. If you want some kind of idea around what kind of documentation that you need for your database then check out the below link. tho this link related to one toll but you can get some idea about this.

http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp

Thanks -- Vj

http://dotnetvj.blogspot.com

Jonathan,

Thanks for the reply. Basically I'm looking for something like 'Red Gate SQL Doc 1' program. I'll check out the links that you posted.

Thanks for your help.

John

SQLDoc Sharp could be the answer.
SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.
This is free solution, Enjoy...!
http://www.amitchaudhary.com/ .

If you want to export the generated documentation to Excel, Pdf or XML then look at, turtle.codeplex.com

Good work.

Really helpful ! Thanks

love it too

Try Dataedo. It reads schema and procedures and functions. You can document each object and column/parameter.

We use Dataedo - you can document tables, views, functions and stored procedures, you can describe using rich text with images, you can group objects into modules, and lastly you can export it to nicely formatted pdf and html.