Determine your SQL Server Version, Service Pack, and Edition

To determine the version of SQL Server, you can use any of the following methods:

Method 1

Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.

Method 2

Connect to the instance of SQL Server, and then run the following query:

Select @@version

An example of the output of this query is as follows:

Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64)   Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

Method 3

Connect to the instance of SQL Server, and then run the following query:

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

Note This query works with any instance of SQL Server 2000 or later

The following results are returned:

• The product version (for example, 10.0.1600.22)
• The product level (for example, RTM)
• The edition (for example, Enterprise)

For example, the results resemble the following:

10.0.1600.22 RTM Enterprise Edition

Note The SERVERPROPERTY function returns individual properties that relate to the version information, although the @@VERSION function combines the output into one string. If your application requires individual property strings, you can use the SERVERPROPERTY function to return them instead of parsing the @@VERSION results.

VERSION INFORMATION

SQL Server 2012 version information

The following table lists the major releases of SQL Server 2012:

Release	Product Version
SQL Server 2012 Service Pack 1	11.00.3000.00
SQL Server 2012 RTM	11.00.2100.60

SQL Server 2008 R2 version information

The following table lists the major releases of SQL Server 2008 R2:

Release	Product version
SQL Server 2008 R2 Service Pack 2	10.50.4000.0
SQL Server 2008 R2 Service Pack 1	10.50.2500.0
SQL Server 2008 R2 RTM	10.50.1600.1

SQL Server 2008 version information

The following table lists the major releases of SQL Server 2008:

Release	Product version
SQL Server 2008 Service Pack 3	10.00.5500.00
SQL Server 2008 Service Pack 2	10.00.4000.00
SQL Server 2008 Service Pack 1	10.00.2531.00
SQL Server 2008 RTM	10.00.1600.22

SQL Server 2005 version information

The following table lists the major releases of SQL Server 2005:

Release	Product version
SQL Server 2005 Service Pack 4	9.00.5000.00
SQL Server 2005 Service Pack 3	9.00.4035
SQL Server 2005 Service Pack 2	9.00.3042
SQL Server 2005 Service Pack 1	9.00.2047
SQL Server 2005 RTM	9.00.1399

SQL Server 2000 version information

The following table lists version number of the Sqlservr.exe file:

Release	Product version
SQL Server 2000 Service Pack 4	8.00.2039
SQL Server 2000 Service Pack 3	8.00.760
SQL Server 2000 Service Pack 3	8.00.760
SQL Server 2000 Service Pack 2	8.00.534
SQL Server 2000 Service Pack 1	8.00.384
SQL Server 2000 RTM	8.00.194

For more information, please refer to Microsoft KB321185 – How To Identify your SQL Server Service Pack Version and Edition.

Ref : lumension

WINDOWS SERVER 2012 AND R2 (EDITIONS/VERSIONS)

Editions/Versions

Windows Server 2012 has four editions: Foundation, Essentials, Standard and Datacenter.

Specifications	Foundation	Essentials	Standard	Datacenter
Distribution	OEM only	Retail, volume licensing, OEM	Retail, volume licensing, OEM	Volume licensing and OEM
Licensing model	Per server	Per server	Per CPU pair + CAL	Per CPU pair + CAL
Processor chip limit	1	2	64	64
Memory limit	32 GB	64 GB	4 TB	4 TB
User limit	15	25	Unlimited	Unlimited
File Services limits	1 standalone DFS root	1 standalone DFS root	Unlimited	Unlimited
Network Policy and Access Services limits	50 RRAS connections and 10 IAS connections	250 RRAS connections, 50 IAS connections, and 2 IAS Server Groups	Unlimited	Unlimited
Remote Desktop Services limits	50 Remote Desktop Services connections	Gateway only	Unlimited	Unlimited
Virtualization rights	N/A	Either in 1 VM or 1 physical server, but not both at once	2 VMs	Unlimited
DHCP role	Yes	Yes	Yes	Yes
DNS server role	Yes	Yes	Yes	Yes
Fax server role	Yes	Yes	Yes	Yes
UDDI Services	Yes	Yes	Yes	Yes
Print and Document Services	Yes	Yes	Yes	Yes
Web Services (Internet Information Services)	Yes	Yes	Yes	Yes
Windows Deployment Services	Yes	Yes	Yes	Yes
Windows Server Update Services	No	Yes	Yes	Yes
Active Directory Lightweight Directory Services	Yes	Yes	Yes	Yes
Active Directory Rights Management Services	Yes	Yes	Yes	Yes
Application server role	Yes	Yes	Yes	Yes
Server Manager	Yes	Yes	Yes	Yes
Windows Powershell	Yes	Yes	Yes	Yes
Active Directory Domain Services	Must be root of forest and domain	Must be root of forest and domain	Yes	Yes
Active Directory Certificate Services	Certificate Authorities only	Certificate Authorities only	Yes	Yes
Active Directory Federation Services	Yes	No	Yes	Yes
Server Core mode	No	No	Yes	Yes
Hyper-V	No	No	Yes	Yes

Also View :

• View WINDOWS SERVER 2012 AND R2 (OVERVIEW)
• View WINDOWS SERVER 2012 AND R2 (HISTORY)
• View WINDOWS SERVER 2012 AND R2 (FEATURES)
• View WINDOWS SERVER 2012 AND R2 (SCALABILITY)
• View WINDOWS SERVER 2012 AND R2 (SYSTEM REQUIREMENTS)
• Changes introduced in WINDOWS SERVER 2012 R2