How do I identify the version (patch level) of an SQL company database in GP
Posted on 2010-11-29
I applied a service pack to both my Production and test GP 9 installations (on SQL 2005 Express). I then took a backup of a company database from production and restored it to my test server. When I tried to start test GP the GP_loginerrors.log said that the database was version 90372 and the client version is 90385. I could not open test GP until I had upgrade the restored table. Since I patched both production and test everything should be at 80385. We are not getting errors when opening GP on the production server. How can I check the production server to make sure that the company databases updated correctly? Is there a query to ask for version information of the company database?