Looking for tables in 2007

I

Ismael

We know where are the tables MSP_VIEW_PROJ_ASSN_TP_BY_DAY and MSP_TEXT_FIELDS
in Project Server 2003, but:
Where are they or their equivalents in Project Server 2007?

We need to know where are the equivalent collumns for
MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeActualWork,

MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeActualOvertimeWorkProtected,
MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart,
MSP_TEXT_FIELDS.TEXT_REF_UID,
MSP_TEXT_FIELDS.TEXT_FIELD_ID,
MSP_TEXT_FIELDS.TEXT_CATEGORY and
MSP_TEXT_FIELDS.TEXT_VALUE
in Project Server 2007.
 
R

Rod Gill

Hi,

Those tables do not exist in Project Server 2007. Instead 2007 now has a
separate reporting database. There is a description of every table and view
in the Project Server SDK which you can download from microsoft.com

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run a query in the MPD File 0
Create a query in a new database 1
Help with Query for Filtered Report 1
Help with an Access Report 1
Regarding the changes in the field data in MSP03 application 0
There are no data in MSP_VIEW_PROJ_ASSN_TP_BY_DAY 3
Unable to get some VIEW's in Project Server 2007 !! 7
Pulling data from 2007 4

Top