Can we add comments or a README file to the SQL Server database / table?

Question

These days I import quite a lot of databases from my server and work on them locally. In the process, I make a number of changes to the table structure and in the process, using several complex SQL statements to add table columns.

Keeping track of everything in a separate file is starting to hurt, and I wonder if there is a way to do this directly in SSMS so that I can store instructions along with the database. Can this be done, or do I need to resort to writing documentation outside of SQL Server?

Of course, I can always create a stub table with comments and post everything there, but I was looking for a way to associate comments with a specific database or tables. Any suggestions would be greatly appreciated.

Answer 1

SQL-Server processes comments on database objects through advanced properties:

http://msdn.microsoft.com/en-us/library/ms190243.aspx