A tutorial that shows how to document SQL Server database with Visual Studio and then export it to PDF and HTML.
Database Tools Articles
This article presents 8 different types of tools you can use to create a documentation of your existing databases.
A comparison between two database documentation tools - Dataedo and Redgate SQL Doc.
Probably most complete list of Data Dictionary tools on the web.