For those of you who are willing to pay a bit, there's a product that does just that:

http://www.nobhillsoft.com/Randolph.aspx

install and setup is quick. more than just version control for the entire schema (tables included) it also provides clear reports, search through history, script at any point in time, rollbacks, email aleerts when things change, pushing schema into sourcesafe, subversion, TFS, and more...