Here is an interesting method for keeping track of modifications brought to an SQL Server database structure:

http://www.codeproject.com/KB/database/sql2005dba.aspx

This is quite useful when working on a new version of a database driven web site, since all modifications made to the development database will eventually have to be applied to the QA database and finally the production database.