About
myself
My
technical skills
My favorites
My picture album
Shortcut
keys
My code library
VB resources
SQLServer
resources
SQLServer
books
Replication
FAQ
Scripting
resources
ASP resources
Search my site
Sign my guestbook
Contact
information
SQL Server Articles New
|
NEW!!! Subscribe to my
newsletter:
| Want to
keep in touch with the latest in SQL Server world? Email vyaskn@hotmail.com
with
'subscribe' in the subject line |
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
For VB code to find out the version and service pack information of SQL Server, click here
Microsoft recently came up with a 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.
|