Buck Hodges' VSTS 2005 and 2008: Building Database Projects with Team Build
While this is specifically about Team Build, it applies to any kind of automated build process using MSBuild. We're still using CCNet as our primary Build engine but Team Build is looking more appealing with 2008.