Determine SQL Server Version

Usually when taking over a new position as DBA, or when discovering a new server in your existing environment, you need to determine what version of SQ Server is installed. This can be accomplished in a few different ways.

Using SSMS

By using SQL Server Management Studio (SSMS) and right clicking on the instance name, you can display the properties of the instance selected. In the general section, you will see the relevant information such as version. The “Version” value gives you a specific version number that is installed.

Using Transact-SQL

SELECT @@VERSION

This will return the version of the product installed.

Windows Properties

You can also locate the installation folder in the Windows Explorer, and right-click on the sqlservr.exe to display the properties as you would any other file. The displayed properties will also display the version of the executable, which should also match the standard version numbers you might expect to see from within SQL Server.

SQL Server Versions

The general version numbers can be matched to the major versions of SQL Server, but the specific version numbers are important to see what updates or patches are installed.

  • 8.0 for SQL Server 2000
  • 9.0 for SQL Server 2005
  • 10.0 for SQL Server 2008
  • 10.5 for SQL Server 2008 R2
  • 11.0 for SQL Server 2012
  • 12.0 for SQL Server 2014
  • 13.0 for SQL Server 2016

You can see specific versions here and here.

Advertisements

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