This is fairly simple, as the Project Server database is really broken up into
three seperate pieces.
In the table structure we have our MSP_, MSP_WEB_, and MSP_VIEW_ tables.
Pretty much the structure is self explanitory.
The MSP_ tables are tables which hold data for the physical project plan.
When opening files within Project Professional the information is pulled for
the MSP_ tables.
The MSP_WEB_ tables hold the data for all of our web front-end. So when a
user logs into Project Web Access, and decides to browse through projects,
etc... then the information is taken from the MSP_WEB_ tables.
As for the MSP_VIEWS_ tables, these contain the information relating to
Project Server's OLAP cube, and that information is taken and populated
there when you do your cube builds.
This white paper will go further into our database structure:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
dnproj2002/html/projsvrarch.asp
Hope that helps,
Matt S.
Project Server Specialist
[email protected]
-----Original Message-----
Can someone explain the difference in functionality between the
msp_assignments table and the msp_web_assignments table?
