SQL DB for Project Server 2003

[Frank M]

Is there some information source I can use to obtain the descriptions of each
of the field names in the tables for the SQL data base for Project Server
2003?

I already have information on the table names, field names, and field
attributes. But I'm lacking information on table relationships and more
descriptive definitions of what each field represents so I can find the data
I want to report on.

I'd like to run some reports using SQL queries (in read-only mode) against
the DB.

 

[Joshua Tan]

Hey Frank,

I'm not sure if you've tried downloading the Project ERD. You might have
since you said you've got descriptions of the table and so on.

No harm trying this link:
http://www.microsoft.com/downloads/...C2-3AC1-4FC8-8E67-D908CDB9FAF2&displaylang=en

Hope that helps.

 

[Marc S.]

Look for the two HTML documents named "PJDB" and "PJSVRDB" on the computer
running Project Server 2003. These files contain information on all tables of
the DB as well as their columns. However you won't find an ERD.

Hope this helps...
Marc