Need Database Schema of MS Project Server 2007

[Ashish kanoongo]

Hello

We have installed MS Project server 2007 with Sql Server 2000 and published
3-4 reports. Now I want to generate burn report of all the employees who are
involved in various project for each week.

Is there this type of any report included? Or Do I need to create, if yes is
there any place where I get the complete database schema of MS Project
Server database in detail?

Regards

Ashish

 

[Rod Gill]

Hi,

Microsoft have said they will not release the schema of all dbs as they need
to reserve the right to change it as needed. However they have published the
schema of the Reporting db. All your queries should be against Reporting db
tables and Views. The reporting db schema is included in the SDK here:
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en

--

Rod Gill
Project MVP

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