<Rick Todd>Can I just install the IDE, and get all the unit test stuff working, or do I need to install the server side as well?</Rick Todd>

You shouldn't need to install a Team Foundation Server but I believe you need to have one of the Team System products installed on your workstation. It might be worth pushing for a Team Foundation Server though; it's worth just to get rid of SourceSafe! However, if you've already switched to another source control system it might not be as big of a sell to you or your management.

[Edit]Grant beat me to the punch and notes that you can lay DBPro on a Non-Team System Visual Studio installation.