SQL Documentor from Vale Software is designed to help all SQL & MSDE developers by quickly and effectively generating complete documentation detailing your databases.
The output is completely customisable to show only the things you want to see. It shows the tables, column names, data types and sizes, default values, users and rules. You can report on everything that you would want.
You can export to RTF and PDF Formats.