SQl and Project Server2003

A

Alexander Moog

Hi!

Did somebody know how the Project Server 2003 saves the content of the
different fields to the Database?
Did he use standard sql statements?
I search for the file where the server makes the insert statement.

Thank you for helping.
 
D

Deepu

Hi,

Yes, Project Server uses plain SQL statements to insert,
update and infact listex.. I was hoping to find something
fantastic in SQL products which I could use in my
application but then MSP uses plain SQL...

One way I found out the stored procedures and the sql
statements following an operation ( like File-Open, File-
Save.. ) is by running profiler and tracing out the SQL
statements. One another way is to use the Object Explorer
in SQL Query Analyzer ( F8 ) and checking out the stored
procedures under ProjectServer database...

Hope it helps..
Regards
Deepu Chacko
 
Top