x

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
more ▼

asked Jan 28 '11 at 02:01 PM in Default

laxman gravatar image

laxman
41 2 4 6

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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
more ▼

answered Jan 29 '11 at 10:55 AM

Magnus Ahlkvist gravatar image

Magnus Ahlkvist
15.9k 15 19 32

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x235
x3

asked: Jan 28 '11 at 02:01 PM

Seen: 1105 times

Last Updated: Jan 29 '11 at 10:45 AM