Dave McKinstry has written a three-part series on building database projects. He includes information on building in TFS Build as well.
- Part I – Introduction to Microsoft Visual Studio 2005 Team Edition for Database Professionals
- Part II – Build, Deploy and Database Connections
- Part 3 - Database Testing during build
Check it out!