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, synonyms, symmetric and asymmetric keys, and user defined functions and types in your database.