Which field in the DB contains Project 'Owner'

[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.

 

[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