Negative ASSN WORK for Resource in the PUB.MSP_ASSN_ENTERPRISE TABLE RRS feed

  • Question

  • Hello, we have a few resources in our published database that has negative ASSN_Work (-9223372036843480000.000000) in the PUB.MSP_ASSN_ENTERPRISE TABLE. What does this mean?

    Friday, June 19, 2015 5:47 PM

All replies

  • Given the fact that the .pub schema is not publicly documented, I'm sure it's significant to the internal working of the tool. The only data schema that should be utilized for reporting, etc is the dbo tables and views. Otherwise, you can inadvertently create locks and other such issues within the tool.

    Hope this helps.

    Treb Gatte | Blog | Twitter | CIO Magazine Blog

    Friday, June 19, 2015 6:53 PM