Hello. Thanks for visiting.

Have questions about Server Intellect?

I'm here to help.

Call us toll free at 1-855-850-HOST(4678)

Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

How to determine SQL Server version/service pack

This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack (SP) level. It also describes how to identify the specific edition if you are using Microsoft SQL Server 2000 or Microsoft SQL Server 2005.

How to determine which version of SQL Server 2000 is running

To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The results are:
  • The product version (for example, 8.00.534).
  • The product level (for example, “RTM” or “SP2″).
  • The edition (for example, “Standard Edition”).
For example, the result looks similar to: 8.00.534 RTM Standard Edition The following table lists the Sqlservr.exe version number: Release Sqlservr.exe RTM 2000.80.194.0 SQL Server 2000 SP1 2000.80.384.0 SQL Server 2000 SP2 2000.80.534.0 SQL Server 2000 SP3 2000.80.760.0 SQL Server 2000 SP3a 2000.80.760.0 SQL Server 2000 SP4 2000.8.00.2039

How to determine which version of SQL Server 2005 is running

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The results are:
  • The product version (for example, “9.00.1399.06″).
  • The product level (for example, “RTM”).
  • The edition (for example, “Enterprise Edition”).
For example, the result looks similar to: 9.00.1399.06 RTM Enterprise Edition The following table lists the Sqlservr.exe version number: Release Sqlservr.exe RTM 2005.90.1399 SQL Server 2005 Service Pack 1 2005.90.2047 SQL Server 2005 Service Pack 2 2005.90.3042

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.