If you aren't looking for a SQL source control tool, you might be looking for a SQL schema diff/comparison tool. One of the most popular ones that I know of (which is also by RedGate) is called
SQL Compare[
^]. Visual Studio 2010 Ultimate and Database editions have pretty good database comparison tools built in. There are also less feature-rich free tools like
Open DBDiff[
^] that you may want to try.