i would suggest 2 tools that we use can help maintaining the database structure.

1. RedGate SQLCompare

2. VS 2008 Database Edition

these 2 allows you to compare and keep track database structural changes. you can even script the database and use that as master script and compare that with the database whenever there are changes made. it will show the changes really good. both tools that are life savers.