How do I integrate with SourceSafe or TFS-VC?

Where can I find information about how to integrate a SQL 2005 database with either SourceSafe or Team Foundation Server Version Control?

I would like to have database changes for tables, views, stored procs, etc. under source control. Is this even possible?

You do not integrate the database itself with source control.

What gets integrated is your development environment. (i.e. Management Studio and BID Studio).

Basic steps are
1) Install Management Studio and BID Studio
2) Install VSS (and create source control database and users)
3a) In Management Studio create new SQL Server Scripts project / solution
3b) In BID Studio create new Integration Services Project
4) In solution explorer (for either prject), right click and select Add To Source Control.

For the most part that should do it...