You could try SchemaToDoc (
http://www.schematodoc.com). It creates a Word document that includes info about your database - primary keys, fields (type, size, nullable, defaults), indexes, check constraints, foreign keys, triggers, views, stored procedures, and extended properties. It also includes an interface that lets you annotate your tables and fields.