Querying Calendar Information direct from database

[Paul Conroy]

I want to query resource enterprise calendar information directly from the
database. I’m having trouble identifying which table(s) hold this data. Any
guidance would be greatly appreciated.

Cheers

Paul

 

[Gary L. Chefetz [MVP]]

Paul:

You can find the data dictionaries for both the Project and Project Server
tables in the database in the help folder on your server where your software
is installed. Look for svrdb.htm and prjdb.htm.

 

[Gary L. Chefetz [MVP]]

Paul:

I re-read your question and I must apologize for my previous answer. While
the data dictionaries are a valuable resource, the simple fact is that
resource calendar data is not exposed for query in the database. You'll need
to use the Project API to get at this data.