Table SQL server using for the resource pool

R

Reznor

I search the table SQL Server where is recording the resource pool.
I need to find the day of a resource is not working on the SQL Database.
In MSP_calendar_data, i find the non working day but for a publish project.
If the project aren't published, the non-working day isn't updated for the
resource.
Wich table contains the non working of a resource as the resource spool.
 
G

Gary L. Chefetz [MVP]

Reznor:

You can't find what isn't there. Unfortunately, in this iteration, the
calendar data is stored in the binary record. You'll need to use the Project
Object Model to get at it. We have an add-on solution that exposes this data
in a table and allows users to self-manage their non-working time.
 
R

Reznor

Thank you for your rapid answer.
But in wich binary record there is ?
What is Project Object Model ?
 
G

Gary L. Chefetz [MVP]

Reznor:

You need to be a developer to access the data. You do this through he
Project Object. If you look at the database, you'll notice that there are
fields defined as BLOBs. The data you can see in the database is an
incomplete extraction of the data stored in these fields.
 

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

Top