Dave McKinstry has written a three-part series on building database projects.  He includes information on building in TFS Build as well.

Check it out!