To determine the service pack that's installed on your SQL Server, open ISQLW (Query Analyzer) or ISQL or OSQL. Connect to your server. Execute the following command:
SELECT @@VERSION
GO
The 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
(RTM or Golden) 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
(Hydra) 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
(Sphinx) 7.00.623 7.00.699 7.00.842 7.00.961 7.00.1063
SQL Server 2000
(Shiloh) 8.00.194 8.00.384 8.00.534 8.00.760 8.00.2039
SQL Server 2005
(Yukon) 9.00.1399.06
Apart from SELECT @@VERSION, there are other commands too, that show you the build number. Try, sp_server_info and master..xp_msver. In SQL Server 2000, there is a new system function called SERVERPROPERTY, that returns service pack information. Here is an example:
SELECT SERVERPROPERTY('ProductLevel')
GO
|
| Author: critic 18 Jul 2006 | Member Level: Bronze Points : 0 |
http://vyaskn.tripod.com/sqlsps.htm
|