Enterprise Project Types in the Project Server 2010 Reporting Database
Recently I was asked where the Enterprise Project Types are stored in the Project Server Database, as my colleague couldn’t see them in the expected MSP_EpmProject_UserView location within the Reporting Database. The data in question actually sits in the MSP_EpmEnterpriseProjectType table.
Here is a query I wrote which will bring them out;
MSP_EpmEnterpriseProjectType ON MSP_EpmProject_UserView.EnterpriseProjectTypeUID = MSP_EpmEnterpriseProjectType.EnterpriseProjectTypeUID