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.