question

laxman avatar image
laxman asked

Need the table name where the "Internal USE Description" saved on Data Base in TFS (Team Foundation)

Hi All, I need the table name and Data Base name where all the Internal Use Description: (Development only) values are saved in the Team Foundation Server. Need where these data is stored in the DB (Table name & DB name please) - Description: - Symptoms: - Steps to Reproduce: - Description: - Internal Use Description: (Development only) - Feedback to client: (Development only) Thank
databasetfs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
The schema of Team Foundations Server's database isn't really a SQL Server question. I also wouldn't recommend accessing the TFS tables directly. Since there's no public database documentation for TFS, the table names, column names, relations etc are likely to change between versions. There's a data warehouse cube that you can use to query most data from TFS. You haven't told us which version of TFS you are using. You might, or might not be helped by this article by Jeff Levinson: [** http://visualstudiomagazine.com/articles/2009/03/09/inside-the-tfs-databases-an-occasional-series.aspx**][1] [1]: http://visualstudiomagazine.com/articles/2009/03/09/inside-the-tfs-databases-an-occasional-series.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.