How to determine which SQL Server Service Pack version is running on your server?
There are three main methods to identify SQL Server Service Pack version.
1. select @@version
2. select SERVERPROPERTY('productversion')
3. exec master.dbo.xp_msver
SQL Server 2005 Service Pack Versions
9.00.3054.00 SQL Server 2005 with service pack 2 GDR2.
9.00.3050 SQL Server 2005 with service pack 2 GDR1.
9.00.3042 SQL Server 2005 with service pack 2.
2005.90.2047 SQL Server 2005 with service pack 1
2005.90.1399 SQL Server 2005 with no service pack applied
SQL Server 2000 Service Pack Versions
8.00.2039 SQL Server 2000 with Service Pack 4
8.00.760 SQL Server 2000 with Service Pack 3a
8.00.760 SQL Server 2000 with Service Pack 3.
8.00.532 SQL Server 2000 with Service Pack 2
8.00.384 SQL Server 2000 with Service Pack 1
8.00.194 SQL Server 2000 with no service pack applied
SQL Server 7 Service Pack Versions
7.00.1063 SQL Server 7 with Service Pack 4
7.00.961 SQL Server 7 with Service Pack 3
7.00.842 SQL Server 7 with Service Pack 2
7.00.699 SQL Server 7 with Service Pack 1
7.00.623 SQL Server 7 with no service pack applied
SQL Server 6.5 Service Pack Versions
6.50.479 SQL Server 6.5 with Service Pack 5a (updated)
6.50.416 SQL Server 6.5 with Service Pack 5a.
6.50.415 SQL Server 6.5 with Service Pack 5
6.50.281 SQL Server 6.5 with Service Pack 4
6.50.258 SQL Server 6.5 with Service Pack 3
6.50.240 SQL Server 6.5 with Service Pack 2
6.50.213 SQL Server 6.5 with Service Pack 1
6.50.201 SQL Server 6.5 with no service pack applied
SQL Server 6 Service Pack Versions
6.00.151 SQL Server 6 with Service Pack 3
6.00.139 SQL Server 6 with Service Pack 2
6.00.124 SQL Server 6 with Service Pack 1
6.00.121 SQL Server 6 with no service pack applied
If you know of any other method please post your cooment to this article. |