Jeff Atwood recently asked " Is your database under version control? " Well, is it? It's not as easy as it sounds. Until now, there wasn't a good, scriptable solution to the problem. I'll run through a few of the options I've looked at in the past, but let's jump to to the punchline: The Database Publishing...

We just released Data Dictionary Creator version 1.2 to CodePlex . Version 1.2 adds a lot of great features: Added documentation of tables as well as columns Changed Excel export from HTML based to XMLSpreadsheet to support separate worksheets for Table and Column documentation Improved error handling...

[UPDATE] A newer version of DDC has been released to Codeplex Summary Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes...