Migrated to MOSS 2007 SP1 or EPM 2007 SP1 .. checking your database schema version

Updated with Infrastructure update Information (July 15th, 2008)

You have decided to migrate to the SP1 of EPM 2007 and/or MOSS 2007.

During the upgrade (done by the configuration wizard), the databases are upgraded also.

If you want to check the schema version of the databases, you can use this query in any of your farm database:

SELECT * FROM Versions

The very last version that maps to the GUID {00000000-0000-0000-0000-000000000000} with the highest ID should equal the current version of the product

Here is a table showing the different database versions

(Thanks Brian https://blogs.msdn.com/brismith)

Updated with Infrastructure Update Information

WSS:https://support.microsoft.com/kb/95165

Office Server https://support.microsoft.com/kb/951297

If you attach a RTM content database or if you provision a new project server site with four RTM databases on a SP1 installation, the RTM databases are upgraded to SP1 during the provisioning.

You may have less lines in your databases, if they were created after applying the SP1 a Rollup or the infrastructure update.