Wednesday, May 2, 2018

How to change / edit XMAL based build definition build controller for all the build definition

update [tbl_BuildDefinition] set ControllerId = xx  where ControllerId =yy


How to disable all XMAL based TFS build definition using SQL Query  ?


Below query will update all Project'e xmal based build definition to be disabled

ANS : update  [tbl_BuildDefinition] set QueueStatus = 2