Add the default configuration to the ConfigurationToBuild ItemGroup as shown below (make sure to match it to your settings in the Configuration Manager)<ItemGroup><!-- CONFIGURATIONSThe list of configurations to build. To add/delete configurations, edit this value. For example,to add a new configuration, add the following lines:<ConfigurationToBuild Include="Debugx86"><FlavorToBuild>Debug</FlavorToBuild><PlatformToBuild>x86</PlatformToBuild></ConfigurationToBuild>The Include attribute value should be unique for each ConfigurationToBuild node.--><ConfigurationToBuildInclude="ReleaseAny CPU"><FlavorToBuild>Release</FlavorToBuild><PlatformToBuild>Any CPU</PlatformToBuild></ConfigurationToBuild>

<!--Include the configuration to build this generates a .sql file in the drop folder--><ConfigurationToBuildInclude="DefaultAnyCPU"><FlavorToBuild>Default</FlavorToBuild><PlatformToBuild>Any CPU</PlatformToBuild></ConfigurationToBuild></ItemGroup>

Next add the following section to the end of the TFSBuild.proj file. the %3B is the escape character for ';' in MSBuild

If you modify your source folder setting in the workspace - defaults to $(SourceDir)- make sure that you override your SolutionRoot property

by adding the following

...

</ProjectExtensions><PropertyGroup>

<SolutionRoot>C:\Workspace_Build02 </SolutionRoot>

....

Thats all there is to it :)

Coming up automatically generate an upgrade script to deploy to production systems... I installed the Database Team Edition on the build agent but I am not quite sure if its necessary I will investigate this... I dont know if its default part of ms build