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
Database | RTM | SP1 | Infrastructure Update July 15th, 2008 |
SharePoint Config DB | 12.0.0.4518 3.0.7.0 3.0.10.0 |
12.0.0.4518 12.0.0.6219 3.0.7.0 3.0.10.0 |
12.0.0.4518 12.0.0.6219 12.0.0.6318 3.0.7.0 3.0.10.0 |
SharedServices DB | 12.0.4518.1016 12.0.1.0 |
12.0.4518.1016 12.0.6219.1000 12.0.1.0 |
12.0.4518.1016 12.0.6219.1000 12.0.6318.5000 12.0.38.0 12.1.503.0 |
WSS Content DBs | 12.0.0.4518 3.0.149.0 |
12.0.0.4518 12.0.0.6219 3.1.3.0 |
12.0.0.4518 12.0.0.6219 12.0.0.6318 3.1.5.0 |
Archive | 12.0.57.0 | 12.0.4518.1016 12.0.6218.1000 12.1.104.0 |
12.0.4518.1016 12.0.6218.1000 12.0.6318.5000 12.1.153.0 |
Draft | 12.0.58.0 | 12.0.4518.1016 12.0.6218.1000 12.1.104.0 |
12.0.4518.1016 12.0.6218.1000 12.0.6318.5000 12.1.153.0 |
Published | 12.0.64.0 | 12.0.4518.1016 12.0.6218.1000 12.1.106.0 |
12.0.4518.1016 12.0.6218.1000 12.0.6318.5000 12.1.162.0 |
Reporting | 12.0.52.0 | 12.0.4518.1016 12.0.6218.1000 12.1.102.0 |
12.0.4518.1016 12.0.6218.1000 12.0.6318.5000 12.1.151.0 |
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.