project server 2007 migration

[Mike Reeves]

I see how I can verify that Project server 2003 SP2a has been applied:

select replace(str(WADMIN_VERSION_MAJOR)+'.'+str(WADMIN_VERSION_MINOR),'
','') as 'Project Server Version' from dbo.MSP_WEB_ADMIN

but does this also verify that the 'Upgdb112.cmd' has been run on the
ProjectServer DB?

Mike

 

[Nico Oosthuysen]

Mike,

When the output of that shows you that the Major version is 11 and the
minor version is 2 then most likely the SP2A script has been applied.
Of course these entries might have been configured such manually
without the script being run. In this case i would normally simply
run the upgrade script again - as far as i know it does no harm...

Nico