Listing 1, Inside the TFS Databases, Part 2

[ID] 			[int] 		NOT NULL,
[ParentID] 		[int] 		NOT NULL,
[Node Name] 		[nvarchar](255) NULL,
[Node Type] 		[nvarchar](128) NULL,
[InDeletedTreeFlag] 	[bit] 		NOT NULL,
[InAdminOnlyTreeFlag] 	[bit] 		NOT NULL,
[Team Project] 		[nvarchar](255) NULL,
[Area Level 1] 		[nvarchar](255) NULL,
[Area Level 2] 		[nvarchar](255) NULL,
[Area Level 3] 		[nvarchar](255) NULL,
[Area Level 4] 		[nvarchar](255) NULL,
[Area Level 5] 		[nvarchar](255) NULL,
[Area Level 6] 		[nvarchar](255) NULL,
[Area Level 7] 		[nvarchar](255) NULL,
[Iteration Level 1] 	[nvarchar](255) NULL,
[Iteration Level 2] 	[nvarchar](255) NULL,
[Iteration Level 3] 	[nvarchar](255) NULL,
[Iteration Level 4] 	[nvarchar](255) NULL,
[Iteration Level 5] 	[nvarchar](255) NULL,
[Iteration Level 6] 	[nvarchar](255) NULL,
[Iteration Level 7] 	[nvarchar](255) NULL,
[Area Path] 		[nvarchar](4000)NOT NULL,
[Iteration Path]  	AS ([Area Path]),
[Changed Date] 		[datetime] 	NOT NULL

About the Author

Jeff Levinson is the Application Lifecycle Management practice lead for Northwest Cadence specializing in process and methodology. He is the co-author of "Pro Visual Studio Team System with Database Professionals" (Apress 2007), the author of "Building Client/Server Applications with VB.NET" (Apress 2003) and has written numerous articles. He is an MCAD, MCSD, MCDBA, MCT and is a Team System MVP. He has a Masters in Software Engineering from Carnegie Mellon University and is a former Solutions Design and Integration Architect for The Boeing Company. You can reach him at Jeff.Levinson@nwcadence.com.

comments powered by Disqus
Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.