[dba-SQLServer] Version Control Integration

Anyone have suggestions about the best way to integrate version control with
SQL 2005? Obvious products include VSS and Subversion. I'm polling for
experiences with both, and also asking whether there is some other product I
should look at. At my new workplace, we don't have anything installed in
terms of version control. This scares me and I want to do something about it
asap.

TIA,
Arthur