Project Server 2003 SQL DB

F

Frank M

Is there somewhere I can access to provide a SQL DB listing of Project Server
2003 tables, fields, field attributes, indexes, table relationships, and
table/field descriptions? I need to generate some reports from the data
using standard SQL queries? Since it is a standard SQL database, I should be
able to access and generate reports from the data over and above the
capability provided in the Project Server application itself.

For example, I need a report (to replace an existing report we had prior to
Project Server 2003 deployment) that provides resource name, hours worked on
all tasks (across projects -- including administrative), dates worked, team
involved, etc. This would need to be a custom report and I need descriptions
of the fields to identify WHERE the data would be located in the SQL data
base.

How do I get this information?
 
A

Ada Pan [MSFT]

Hello Frank,

From the post log, it seems a Project issue. As Bob and Steve suggested,
for Project side questions, we have dedicated newsgroup:

microsoft.public.project.server

Please submit your question to those newsgroups, as there are more
qualified pools of respondents who can give you suggestions. Meanwhile,
other partners who visit the newsgroups regularly can either share their
knowledge or learn from your interaction with us.

Thank you for your understanding.

Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top