Project Server 2007: MSP_ASSIGNMENT_TRANSACTIONS table - decoding CHANGE_DATA fields RRS feed

  • Question

  • Is there any way via SQL to decode the data in the ASSN_CHANGE_DATA and TASK_CHANGE_DATA fields?  I would like to get at the particular fields that were updated so I could show data similar to that in the "Applied Task Updates and Errors" screen (e.g. was % complete, start, finish date changed, etc.)  I can join to the draft database and see what the current value of the assignment fields are, but for an update in the past I can't tell what they were changed to.

    Terrie T - MCTS - PMP - MBA PMO & Project Server Admin
    Monday, December 13, 2010 3:04 PM

All replies