You should seriously consider keeping your scripts under source
control as Erland has suggested, especially if you will end up working
on the database with other developers. It's a great way to keep
everyone's activities in sync.

Check out DB Ghost (http://www.dbghost.com) - we've been doing this
for about 5 year's now and Microsoft, Red Gate and xSQL have now also
realised what we've been saying makes sense and incorporated our
thinking into theor products i.e. the approach has now been validated
across the board so you really should give it some thought.