Project Server 2003 and SQL report....

[Vit]

Hi all,

I'm trying to understand the Database of Project server 2003...

Is there any white paper??

For example, what tables in SQL can I tap into to create some custom
reports using 3rd party software????

Any suggestion to increase my knokledge into the SQL sde of Project
Server?

Thanks

Cheers

Vit

 

[Gary L. Chefetz]

Vit:

Look in the help directory of your Project Server installation for Prjdb.htm
and svrdb.htm. These are data dictionaries for Project and Project Server
2003.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Sean Hanson]

SRS works really well with 2003 and 2007, you might check out the main page:
http://www.microsoft.com/Sqlserver/2005/en/us/reporting-services.aspx an
http://www.microsoft.com/downloads/...8C-8BCA-4DB9-8753-178C0D3099C5&displaylang=en the 2003 SDK.


--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs