I would recommend you to use SQL Server Mangement Studio itself, but try to set up CVSNT ( Concurrent Versioning System - its free - Open source) and the great thing is you can integrate SQL Mangement Studio with CVS. You can use wincvs as a client to access the CVS Server. Setting up the CVS server and client are a breeze if you know what you are doing... There are plenty of resources on the net too. So you can maintain source control easily with no cost. Mail me if you need further instructions on integrating SSMS with CVS.

Hi, CVS SCC proxy is a SCC API plug-in which provides access from all Microsoft SCC enabled software to general CVS repositories. The Microsoft SCC API is supported by: MS VC 5.0-7.0, MS VB 5.0-7.0, MS .NET, MS FrontPage, MS DEV and other Microsoft development tools. You can use the PUSHOK's CVS SCC proxy, configure it and developers can access CVS right from the Microsoft IDEs like SQL Server 2005 Management Studio, Visual Studio 2005, etc. Mail me for a detailed document, which I have compiled for the procedure.