SqlSpec
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, schemas, assemblies, CLR procedures, xml schema collections,... With SqlSpec, it is easy to keep documentation in sync with the actual database, since you can just run SqlSpec on your databases and your documentation gets updated. ... SqlSpec generates output in HTML and CHM format.
http://www.elsasoft.org/sqlspec.zip - 134Kb - Download - Screenshot