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

Installing .NET Framework 3.5 Features on Windows Server 2012 R2

Windows Server 2012 R2

Open “Server Manager” on your “Windows Server 2012 R2”:

Server Manager

Click “Add roles and features” and the following screen will come:

Add Roles and Features Wizard - Before you Begin

Click “Next” and the following screen will come:

Add Roles and Features Wizard - Select installation type

Select “Role Based”, then “Next” and the following screen will come:

Add Roles and Features Wizard - Select Destination server

Select “a server from the server pool”, then “Next” and the following screen will come:

Note: I have skipped the Server Roles as I need to install only Features here.

Installing DOTNET Framework 35 Features 1

Select “.Net Framework 3.5 Features”, then “Next” and the following screen will come:

Installing DOTNET Framework 35 Features 2

As I installed my windows via DVD so I will click the option of “Specify an alternate source path

Installing DOTNET Framework 35 Features 3

The following screen will come:

Installing DOTNET Framework 35 Features 3b

Note: here we have to specify the “sources\sxs” path from our installation device.

Installing DOTNET Framework 35 Features 4

Now after selecting the path click “Install” following screen will come:

Installing DOTNET Framework 35 Features 5

After some time the following screen will come:

Installing DOTNET Framework 35 Features 6

Finally, the Features for .Net Framework 3.5 are successfully installed.

Installing Visual Studio – Ultimate 2013 with Blend

Visual Studio 2012 - Ultimate 1

To install Visual Studio Ultimate 2013 we are using the following Setup file:

SW_DVD5_VS_Ultimate_2013_English_##_##F_X##-####5

Right Click and Mount, Run “vs_ultimate” Application file as Administrator:

This Screen will Show up:

Visual Studio 2012 - Ultimate 1

Wait for the loading then the following screen will come:

Visual Studio 2012 - Ultimate 2

Note: I have changed the Path so the my Operating Systemdrive (C:\) does not get lot of Load.

Click “I agree” and then Next, then the following screen will come:

Visual Studio 2012 - Ultimate 3 new

Note: We can select what features we need from the above section of “Optional Features to Install”.

Click “Install, then the following screen will come:

Visual Studio 2012 - Ultimate 4 new

After Installation, then the following screen will came:

Visual Studio 2012 - Ultimate Error 5

I did a restart of the Server and AGAIN run the setup of Visual Studio and only one issue remained, the screen was displayed as following :

Visual Studio 2012 - Ultimate Error 7

To resolve issue of Microsoft Web Deploy 3.0 “A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file.”

I googled and found this Microsoft Link, It will download a windows installer file “MicrosoftFixit50531” just run it as Administrator.

Over view of the Error is :

These errors occur because of a failed timestamp comparison in the installer that is caused by an improperly signed Web Deploy Package.If you receive a warning after you successfully complete the installation of Visual Studio 2012, you can fix the problem by installing Web Deploy 3.0.

I did a restart of the Server and AGAIN run the setup of Visual Studio and all issues resolved, the screen was displayed as following :

Visual Studio 2012 - Ultimate 6

Now I clicked “LAUNCH”, following screen came:

Visual Studio 2012 - Ultimate 7 a

Now I clicked “Not now, maybe later”, following screen came:

Visual Studio 2012 - Ultimate 7 b

We have multiple options for “Theme” and “Development Settings”:

Visual Studio 2012 - Ultimate 7 c

Now I clicked “Start Visual Studio”, following screen came:

Visual Studio 2012 - Ultimate 8

It takes some time and we have our Visual Studio Ultimate 2013 “Start Page

Visual Studio 2012 - Ultimate 9

If You look closer to the top right there is a Flag for the “Notification Area”.

Visual Studio 2012 - Ultimate 10

Click “Notification Area” and the following screen appers.

Now you have successfully installed “Visual Studio Ultimate 2013”. Enjoy 😀