SQL queries / procedures

D

dianamj

Hello Guys

Could anyone please send me the queries/ procedures in SQL so that I
take the information from the SQL databases? As I still have little
experience in Project Server I would like to get all the necessary
information on that so that I may be able to better figure out the
system.

Any idea where I might take this info from?

Thanks in advance
 
R

Rod Gill

In PS 2007 there are already numerous Views created for you. Look at the
Views in the Reporting database. The Project SDK has further detail as does
msdn and TechNet.

There are hundreds of columns so you need to create specific Views for
specific reports or use SQL Server reporting Services.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How to Change criteria on a saved query using VBA 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel does not accept text format! 0
Get status messages from Oracle sql queries 0
VBA word change keys 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
"Compile error in table level validation expression " after format 0

Top