Why is this not stupidly easy.
Here's a list of SP's to Version numbers:
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
Wow, I never knew there were so many.
7.x = SQL Server 7.
8.x = SQL 2000/MSDE
SQL Server 2000 Service Pack 4 8.00.2039
SQL Server 2000 Service Pack 3 8.00.760
SQL Server 2000 Service Pack 2 8.00.534
SQL Server 2000 Service Pack 1 8.00.384
SQL Server 2000 RTM 8.00.194
9.x = SQL 2005
SQL Server 2005 Service Pack 4 9.00.5000.00
SQL Server 2005 Service Pack 3 9.00.4035
SQL Server 2005 Service Pack 2 9.00.3042
SQL Server 2005 Service Pack 1 9.00.2047
SQL Server 2005 RTM 9.00.1399
10.x = SQL 2008
10.5 = SQL 2008 R2
11 = SQL 2012
12 = SQL 2014
MSDE: Apply SP4 - make sure to download the MSDE version of SP4. run "setup /upgradesp sqlrun"
tags: sp3, sp4, sqlserver,