Generate a data dictionary using SQL Server 2005 metadata then take it one step further. Use Extended Properties to add additional metadata that will explain why each data object is important to the application that uses it.

This story continues at http://www.databasejournal.com/news/article.php/3678006