After the installation of SP2, the following methods can be used to confirm if the updates have been successfully applied;
1) PWA version – Check the version of PWA via SITE SETTINGS
The version should read: 126.96.36.19921.
2) Project Server Database Version Table. The alternative is to check the Project Server Database Version Table. Right click on the Version table and select ‘Open Table’.
The version should read: 12.0.6422.1000
I would recommend checking all the four Project Server databases rather than simply focusing on the Published DB. The version number should be the same in all the four DBs.
Note: I have experienced a situation where the ProjectServer_Reporting DB failed to upgrade in Step 8 of 9.
To check if Project Professional 2007 has been upgraded correctly, review the version under Help > About Microsoft Office Project.
The version should read: 12.0.6423.1000
Note: The SP2 update includes all the updates upto and including Feb CU.