Red Gate is currently working on a source control solution, which would allow you to source control your database schema right from SQL Server Managment Studio without ever having to script out the objects, http://www.red-gate.com/products/SQL_Source_Control.
answered Oct 30, 2009 at 12:27 PM
Yes, and if you want to use TeamFoundationServer (I like this a lot more than SourceSafe), you can add Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider.
Download it from here http://www.microsoft.com/downloads/
answered Oct 30, 2009 at 04:22 AM