Recently, I need to create a data dictionary for our 12GB database. And I did a research on creating data dictionary, and found this good tool - Data Dictionary Creator. It stores all the information in Extended Properties. Here are some blog link for this cool tool:
Data Dictionary Creator - Rapid database documentation
Generate Sql Server data dictionary table
