SQL Doc
Features
Create database documentation directly from your schema
Add descriptions to tables, views, and columns
Export documentation to HTML or Microsoft Word format
Includes all internal and cross-database dependencies
Supports SQL Server 2000, 2005, and 2008
Latest version 2.0
Path to download
http://www.red-gate.com/products/SQL_Doc/index.htm
Reference: http://www.red-gate.com/products/SQL_Doc/index.htm