SqlSpec download

SqlSpec will generate easy-to-read docs for any SQL Server 2000 or 2005 database. Given one or more connection strings, SqlSpec will generate documentation about all the tables, views, stored procedures, triggers, indexes, constraints, and user defined functions in your database. It will also tell you what the dependencies are (which tables point to other tables via foreign keys, which tables are used by which stored procedures, etc.) It will show the code for each trigger, view, user defined function, check constraint, and stored procedure in the database. In this way, it's easy to keep documentation in sync with the actual database, since you can just run SqlSpec on your databases and your documentation gets updated.