SQL Server Service packs and Versions
Last updated: October 28th '05 | Best viewed with: All popular browsers | Best viewed at: 1024x768 | Links to external sites will open in a new window

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
Click here to read a sample chapter from the book:
SQL Server Security Distilled
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
See also:    
  Database programming guidelines, conventions SQL Server DBA and developer interview questions
  Evaluation of federated database servers SQL Server FAQ on programming, designing, administration, tools, replication
  SQL Server security best practices SQL Server administration best practices

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:


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
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

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:


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.

Disclaimer, terms of use and privacy policy
Copyright 1997 - 2006 Narayana Vyas Kondreddi. All rights reserved.