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!