Baseline Saved Date Database location

[Patrick]

Where does the project server database store the baseline saved date for a
Project in 2003 Project Server SQL database? (This is for the main baseline,
not the 10 numbered baselines).

Is there a good reference document that tells where all the key information
is kept?

Thanks,

Patrick

 

[Rod Gill]

See pjdb.htm and pjsrvrdb.htm in one of proejcts program folders.

 

[Patrick]

Unfortunately these documents do not appear to have the loaction for when a
baseline was saved date. I have reviewed them and cannot locate the table
and field name.

Patrick

 

[Rod Gill]

Some data is only ever stored in a binary blob and is inaccessible to you.
If you are using Project Server, then check the MSP_VIEW tables as they
provide most data in a very readable format.

 

[Ed Morrison]

Patrick

Baseline data is stored on the msp_tasks table in fields that begin with

task_base_.

 

[Patrick]

Any ideas where the saved date (date where the baseline was saved) would be?
I know it is kept somewhere as when you rebaseline MSP2003 lets you know when
it was already baselined.

Thanks

Patrick

 

[Gary L. Chefetz \(MVP\)]

Patrick:

It's in the BLOB. The only way to access this is through the Project Object.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-