SQL Project Server Calendars Tables RRS feed

  • Question

  • Where calendars are store inside sql database? I mean holidays (exceptions) and working weeks entries?
    Wednesday, February 24, 2016 2:12 PM

All replies

  • Hi,

    Project server published database table [MSP_CALENDARS] which contains all the CALENDARS information at project. It can be joined on [MSP_PROJECTS] table to get the CAL_UID but "NOT SUPPORTED".

    See those posts or thread which might also give you some ways to do it:


    Hope this helps,

    Guillaume Rouyre, MBA, MVP, MCC |

    Thursday, February 25, 2016 8:00 AM
  • I dont want to get its links to projects, i want to read its settings and exceptions.

    But i think all this data i need is serialized into CAL_INFO binary field. No way to parse it within going extreme.

    Monday, February 29, 2016 2:44 PM
  • Were you able to parse the Cal_Info binary field and read the Calendar data ? what method did you employ to read the Calendar data in MS Project?

    I am facing a similar issue while trying to read the Calendar info from SQL while calculating the Working days in a date range which is based on the calendar that MS Project utilizes.




    Tuesday, November 7, 2017 5:34 AM