Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Create a Work Item from a Defect in Transact-SQL Code

When you analyze Transact-SQL (T-SQL) code in your database project, you might find potential design, naming, or performance defects but decide to investigate them later. You might also find defects in database code that other team members own. By using Visual Studio Team System Team Foundation Server, you can create a work item to track each defect and then assign that work item to the team member who will investigate it.

Important noteImportant Note:

Before you begin this procedure, you must install Team Explorer and connect to Team Foundation Server, and the Error List must show one or more errors or warnings for which you want to create work items. For more information about how to find errors and warnings about your code, see How to: Analyze Transact-SQL Code to Find Defects.

To create a work item for one defect

  • In the Error List, right-click an error or warning, point to Create Work Item, and click the type of work item that you want to create.

    A work item is created in which you can specify details.

To create a work item for multiple defects

  1. In the Error List, click multiple errors or warnings while you press SHIFT or CTRL.

  2. Right-click any one of those warnings, point to Create Work Item, and click the type of work item that you want to create.

    A single work item is created for the set of errors or warnings that you specified.

Community Additions

© 2015 Microsoft