How to delete WorkItems?

We don't currently provide any means to obliterate individual work items from a project - the only mechanism is to delete an entire project using the DeleteTeamProject tool.

As noted above, this is is largely to support the rich auditing functionality built into Team System, and it also ensures that any links between work items are always preserved.

Historically, this is the way we've dealt with bugs & work items at Microsoft. Work Items are permanent record of work done in your project. It's a way we can be 100% certain that any information gathered regarding the project is always available. For example, we don't rely on email discussions being permanently available - if we have important email discussions about bugs, we'll frequently cut & paste them into the Work Item to ensure that we'll always be able to refer back to the discussion.

Obviously, you should mark the work item you created by mistake as Closed, but if you created a large number of work items by mistake that you wanted to exclude from certain queries then you might want to create a new project hierarchy node to move them into.

JohnLawrenceMSFT at 2007-9-9 >

I want the ability to delete work items as well. If a work item has been related to a check in, then you shouldn't allow it, but if it's just sitting out there, you should be able to remove it.

BrienKing at 2007-9-9 >

Hi,

Like Eric Frick, i import workitems from excel and getting duplicate workitems. It's need be delete but i can't.

any one can build sql srcipt to detele it?

hoangchau at 2007-9-9 >