How can I determine the service pack that's installed on SQL Server?
To determine the service pack that's installed on your SQL Server, open SQL Query Analyzer. Connect to your server. Execute the following command:
SELECT @@VERSION
GOThe output of this command will be something like the one pasted below. The first line of the output displays the version number of the server. The last 3 digits (build number) of the version number are used to determine the service pack installed on your SQL Server.
In this case 623.
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
(1 row(s) affected)SQL Server Version Table:
No SP | SP1 | SP2 | SP3 / SP3a | SP4 | SP5 | SP5a | |
|---|---|---|---|---|---|---|---|
SQL Server 6.0 | 6.00.121 | 6.00.124 | 6.00.139 | 6.00.151 | |||
SQL Server 6.5 | 6.50.201 | 6.50.213 | 6.50.240 | 6.50.258 | 6.50.281 | 6.50.415 | 6.50.416 |
SQL Server 7.0 | 7.00.623 | 7.00.699 | 7.00.842 | 7.00.961 | 7.00.1063 | ||
SQL Server 2000 | 8.00.194 | 8.00.384 | 8.00.534 | 8.00.760 | 8.00.2039 | ||
SQL Server 2005 | 9.00.1399.06 |
Microsoft KB article on this topic:
Q321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
Click here to download SQL Server service packs, tools, add-ins, sample code, updates etc.