Which field in the DB contains Project 'Owner'

J

James Webster

I'm currently looking through all the tables in the project server 2003
database and am looking for the field which tracks the project's ownership
(as editabled from the Project Center -> Edit page).

Thank you.
 
K

Kevin W Flanagan

James-

You will need to get the WPROJ_ID for the project you want to find out who
the owner is. The following query will return the owner for all projects in
your databse:

select res.RES_NAME, proj.PROJ_NAME, res.WRES_ID
from MSP_WEB_PROJECTS proj, MSP_WEB_RESOURCES res
where proj.WRES_ID = res.WRES_ID
order by res.RES_NAME

Hope this helps.

Kevin
 
Top