The annual "What version of SQL Server are we running?" post...

nullinterface - Microsoft SQL Server Versions and Editions

Time and again some partners send in requests and detail out only the version numbers for the SQL Server they're working on. Isn't always permissible for us to go bak to them for further info, so we dwell into the KB articles to determine the correct editions and Service Packs installed to assist the partners the best way possible. I though sharing the collated list could benefit some more of our DB folks.

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

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

How to determine the version and edition of SQL Server and its components

This article describes how to determine your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to determine the specific edition of SQL Server that you are using.

Note If you just need to know what a specific version number of SQL server maps to or the KB information for a specific cumulative update package or a service pack, refer to the section of this article and search for the version number.

Note If you just want to find the latest builds for SQL Server, you can refer to the following article. Or, you can check the tables that correspond to your product in the section of this article. 957826

Where to find information about the latest SQL Server builds

Where to find information about the latest SQL Server builds

This article lists the Knowledge Base articles that provide more information about the following:

• The Microsoft SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1.
• The Microsoft SQL Server 2012 builds that were released after SQL Server 2012.
• The Microsoft SQL Server 2008 R2 builds that were released after SQL Server 2008 R2.
• The Microsoft SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1.
• The Microsoft SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2.
• The Microsoft SQL Server 2008 builds that were released after SQL Server 2008.
• The Microsoft SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1.
• The Microsoft SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2.
• The Microsoft SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 3.
• The Microsoft SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2.
• The Microsoft SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3.
• The Microsoft SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 4

Seems this comes up every year or so, and with the number of supported SQL Server versions out there, I thought it a good time to re-post this info...

 

Related Past Post XRef:
Goodbye @@version, hello xp_msver...
SQL Server Version Number Database (SQL Server 6.5 through 2008 R2 SP1 CTP...)

"Select @@Version" is old school... Check out the ServerProperty function
SQL Server Version Numbers - That @@version number means my SQL Server is running what SP?