The database documentation capabilities Microsoft provides for SQL Server databases are rudimentary. Pretty quickly you are going to be looking for a third party solution. In this brief video tutorial, I demonstrate how Enterprise Architect by Sparx Systems can be used to:
- document columns in a table
- author more detailed explanations of the purpose of tables
- detect changes in a target SQL Server database
Enterprise Architect has a large amount of additional capabilities for modeling business process and software development efforts. It's a rather complicated tool quite frankly. But it is a reasonably priced product that can help your organization communicate about the nature of your data.
For more information visit the Enterprise Architect site.