|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.
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
In the Error List, click multiple errors or warnings while you press SHIFT or CTRL.
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.