Tag Archives: Versions

Determine your SQL Server Version, Service Pack, and Edition

SQL Server

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 (Overview)

Overview for Windows Server 2012, codenamed “Windows Server 8”, is the sixth release of Windows Server. It is the server version of Windows 8 and succeeds Windows Server 2008 R2. Two pre-release versions, a developer preview and a beta version, were released during development. The software was generally available to customers starting on September 4, 2012.

Unlike its predecessor, Windows Server 2012 has no support for Itanium-based computers, and has four editions. Various features were added or improved over Windows Server 2008 R2 (with many placing an emphasis on cloud computing), such as an updated version of Hyper-V, an IP address management role, a new version of Windows Task Manager, and ReFS, a new file system. Windows Server 2012 received generally good reviews in spite of having included the same controversial Metro-based user interface seen in Windows 8.

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 :