---
title: "How can I determine the service pack that's installed on SQL Server?"
slug: "how-can-i-determine-the-service-pack-thats-installed-on-sql-server"
updated: 2024-04-02T13:34:14Z
published: 2024-04-02T13:34:14Z
canonical: "kb.pharos.com/how-can-i-determine-the-service-pack-thats-installed-on-sql-server"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pharos.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How can I determine the service pack that's installed on SQL Server?

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:

```plaintext
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.

```plaintext
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.

## Related

- [Blueprint 5.x: In the Blueprint Administrator under the Terminals I do not have a TAB to configure the Terminal](/blueprint-5x-in-the-blueprint-administrator-under-the-terminals-i-do-not-have-a-tab-to-configure-the-terminal.md)
- [Printing from client printers attached within a remote Citrix or Terminals Services session](/printing-from-client-printers-attached-within-a-remote-citrix-or-terminals-services-session.md)
- [Memory Full" error on a Canon Image Runner Advance 6555i](/memory-full-error-on-a-canon-image-runner-advance-6555i.md)
- [Cannot "Add Associated Terminal" with any terminal type except "Generic" and viewing a terminal in Administrator may not display the terminal's Configuration tab.](/cannot-add-associated-terminal-with-any-terminal-type-except-generic-and-viewing-a-terminal-in-administrator-may-not-display-the-terminals-configuration-tab.md)
- [When I open the Pharos Reports application I get a license error or license warning about unmanaged devices.](/when-i-open-the-pharos-reports-application-i-get-a-license-error-or-license-warning-about-unmanaged-devices.md)