Reading Resource Cost Rate Table data RRS feed

  • Question

  • Is it possible to READ the local and enterprise cost rate table information in Project Server 2003 using an SQL querry?

    How about in 2010?

    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)
    Saturday, November 13, 2010 6:13 PM



    Hi Spiro,

    No, the RES_RATES_TABLE in MSP.RESOURCES is binary data. It's not a good idea for anyone who has admin access to the Project Server Published db, but not necessarily a resource management role, to be able to easily read cost rates of other enterprise resources.

    On the other hand, a project manager can use VBA to read resource cost rate tables (or simply look at the Resource Information dialog box) in a single project that he/she manages in Project Standard or Project Pro.


    Jim Corbin [MSFT]
    • Proposed as answer by Jim Corbin Sunday, November 14, 2010 11:14 PM
    • Marked as answer by Spiro Theopoulos Monday, November 15, 2010 1:02 AM
    Sunday, November 14, 2010 11:01 PM