Have you looked into using Red Gate's SQL Source Control, http://www.red-gate.com/products/sql_source_control/index.htm. It allows you to source control your db schema objects in TFS direclty from SQL Server Management Studio.