none
Project Server 2010 - Find the field RES_LAST_ACTIVITY in database ProjectServer_Reporting RRS feed

  • Question

  • Hello Guys, 

    Which view of SQL Server database data ProjectServer_Reporting I can find the field  RES_LAST_ACTIVITY in database ProjectServer_Reporting or its equivalent name?

    Thanks


    Obrigado por contactar o fórum Microsoft Technet!

    Wednesday, May 14, 2014 8:20 PM

Answers

  • This is available in published DB in MSP_RESOURCES table, for what purpose are you trying to use it for ?

    Since the DB schema's other than reporting are not documented would suggest not to use it directly due to several implications like schema change due to future SP/CU and could cause performance and other problems  


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

    Wednesday, May 14, 2014 9:23 PM
    Moderator

All replies

  • This is available in published DB in MSP_RESOURCES table, for what purpose are you trying to use it for ?

    Since the DB schema's other than reporting are not documented would suggest not to use it directly due to several implications like schema change due to future SP/CU and could cause performance and other problems  


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

    Wednesday, May 14, 2014 9:23 PM
    Moderator
  • Thanks epmXperts.

    Obrigado por contactar o fórum Microsoft Technet!

    Tuesday, May 20, 2014 6:55 PM