I use VSS and for small projects, I've found it to do everything that is needed.
You think those endless database corruptions and warning that you need to analyze the database are "needed"?!!! :O
Used SourceSafe at Ford about 8 years ago and it was a nightmare - we lost the database twice and quickly moved to something else. Then 6 months ago I got a contract where they were using SourceSafe 2005. It seemed like every wretched morning you'd get in to find it warning you that the SourceSafe database needed analyzing and fixing.
It's real fun when you rename files!
It is by far the worst source control system out there. Are there any other than SourceSafe that DON'T support continuous integration?
SourceSafe - just say no!