The following is the list of the SQL Server version. With the help of the following list you can know that what service packs are installed on SQL Server on your machine.
SQL Server 2000
SQL Server 2000 RTM | 8.00.194 |
SQL Server 2000 Service Pack 1 | 8.00.384 |
SQL Server 2000 Service Pack 2 | 8.00.534 |
SQL Server 2000 Service Pack 3 | 8.00.760 |
SQL Server 2000 Service Pack 4 | 8.00.2039 |
SQL Server 2005
SQL Server 2005 RTM | 9.00.1399 |
SQL Server 2005 Service Pack 1 | 9.00.2047 |
SQL Server 2005 Service Pack 2 | 9.00.3042 |
SQL Server 2005 Service Pack 3 | 9.00.4035 |
SQL Server 2005 Service Pack 4 | 9.00.5000.00 |
SQL Server 2008
SQL Server 2008 RTM | 10.00.1600.22 |
SQL Server 2008 Service Pack 1 | 10.00.2531.00 |
SQL Server 2008 Service Pack 2 | 10.00.4000.00 |
SQL Server 2008 Service Pack 3 | 10.00.5500.00 |
SQL Server 2008 R2
SQL Server 2008 R2 RTM | 10.50.1600.1 |
SQL Server 2008 R2 Service Pack 1 | 10.50.2500.0 |
SQL Server 2008 R2 Service Pack 2 | 10.50.4000.0 |
SQL Server 2012
SQL Server 2012 RTM | 11.00.2100.60 |
SQL Server 2012 Service Pack 1 | 11.00.3000.00 |
SQL Server 2012 Service Pack 2 | 11.0.5058.0 |
SQL Server 2012 Service Pack 3 | 11.0.6020.0 |
SQL Server 2014
SQL Server 2014 RTM | 12.0.2000.8 |
SQL Server 2014 Service Pack 1 | 12.0.4100.1 |
SQL Server 2014 Service Pack 2 | 12.0.5000.0 |