Network Programming in .NET

If you’re working with TFS 2010, and you get this message “default controller cannot be deleted because there are builds in progress” when trying to remove a build controller, you should of course check first to see if you can stop the build through the interface, but you can force the issue by running this query in the TFS_DefaultCollection database

update tbl_BuildQueue set status=16

This sets all builds to a status of cancelled.

Or if you prefer, do a select from tbl_buildQueue, and find any one that has a status of 1 (in progress) or 2 (Queueud).

Here are all the statuses

0 – None

1 – In progress

2 – Queued

4- Postboned

8 – Completed

16 – Cancelled