How to Read the Results of SELECT @@VERSION in SQL Server 2005 and 2008

Lately, I’ve seen several questions from people in the MSDN Forums who have been confused about how to interpret the results of running SELECT @@VERSION. 

I always like to see the results of running this query, since I can tell a lot about the system very quickly and easily. I can see the edition of SQL Server (Enterprise, Standard, Developer, etc.), whether it is x86 or x64, the exact Build number, and the operating system version and service pack level.

 

The exact command is shown below:

SELECT @@VERSION

Here are a few examples from some servers that I have easy access to:

One of my Production Servers:

Microsoft SQL Server 2005 – 9.00.3186.00 (X64)   Aug 11 2007 05:31:24   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

This tells me we are running Build 3186, x64, Enterprise Edition on Windows Server 2003 SP2. This build is Cumulative Update (CU) 3 for SQL Server 2005 SP2. The part in bold red is about the operating system, not SQL Server.

 

My Development Workstation:

Microsoft SQL Server 2005 – 9.00.3239.00 (Intel X86)   Apr  9 2008 22:56:02   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

This tells me we are running Build 3239, x86, Developer Edition on Windows XP SP3. This build is CU 7 for SQL Server 2005 SP2.

 

A Katmai Test Server:

Microsoft SQL Server code name "Katmai" (CTP) – 10.0.1315.0 (X64)   Mar 17 2008 11:05:14   Copyright (c) 1988-2007 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

This tells me we are running Build 1315, x64, Developer Edition on Windows Server 2003 SP2. This is a post CTP6 build for SQL Server 2008.

 

Another Katmai Test Server:

Microsoft SQL Server code name "Katmai" (CTP) – 10.0.1300.13 (X64)   Feb  7 2008 22:02:25   Copyright (c) 1988-2007 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)

This tells me we are running Build 1300, x64, Developer Edition on Windows Server 2008. This is the CTP6 build for SQL Server 2008.

 

This Microsoft KB article tells you what builds have been released since SP2 for SQL Server 2005

http://support.microsoft.com/default.aspx?scid=kb;en-us;937137&sd=rss&spid=2855

 

Technorati Tags:
This entry was posted in SQL Server 2008. Bookmark the permalink.

24 Responses to How to Read the Results of SELECT @@VERSION in SQL Server 2005 and 2008

  1. T8tube.com says:

    good

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s