How to identify your SQL Server version and edition

To determine the SQL Server edition, version and service pack installed on your SQL Server, connect to your server and execute one the following commands.

If you are not sure which edition of SQL Server you are running then SELECT @@Version should return you some information.

SQL Server 2005

To determine the which exact 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')

SQL Server 2000

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 from 2000 & 2005 looks like:

9.00.1399.06 RTM Enterprise Edition

  • The product version (for example, 9.00.1399.06).
  • The product level (for example, "RTM" or "SP2").
  • The edition (for example, "Standard Edition").

SQL Server 7 & SQL Server 6.5

To determine which version of Microsoft SQL Server 7 & 6.5 is running, connect to SQL Server 6.5 and then run the following command:

SELECT @@VERSION

 



 3/17/2008


Add Comments
Name: *
Email: *
URL:
Comments: *
 


Advertisements

MySQL HOSTING
MySQL hosting provider, clustering and replication supported. DBA Services Included.

SQL SERVER HOSTING
Reliable, powerful SQL Server 2008 hosting with ASP.NET on Windows 2008 Servers.

SQL Server DBA

I am a SQL Server DBA with almost 9 years of experience in database technologies.

 I am again in process of redesigning this website using ASP.NET 2.0 and AJAX. The main purpose of new SQL DBA website is to offer more features and make it easy for me to update contents on regular basis.