How to get your version of SQL Server

How to get your version of SQL Server

I have been using SQL server for more years than I care to remember, all the way from SQL Server 2005 to SQL Server 2016 that im using for intermittentbug.com.

Microsoft release many different editions such as Express, Web, Standard, Datacentre, not to mention the updated revision such as R2.

It’s important to know the exact version of SQL server you are working with as compatibility among the different editions and new releases can be limited, plus new features of TSQL are available in the newer version which may not be compatible with older editions.

To get the version of SQL server follow these simple steps…

  1. Open SQL Server Management Studio.
  2. Connect to your database.
  3. Click “New Query”
  4. Enter the following SQL and press “F5” to Run
select @@version AS SQLServer_Version

this returns the following when i run on my local machine

Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)   Apr 29 2016 23:23:58   Copyright (c) Microsoft Corporation  Express Edition (64-bit) on Windows 10 Enterprise N 6.3 <X64> (Build 14393: ) 


JGilmartin Profile Image

JGilmartin

Technical Architect at Pinewood Technologies

Rating: 2890

C# Expert

Offline


Useful Tip Statistics
  • Views: 380
  • Comments: 0
  • Author: JGilmartin (2890)
  • Date: 26/11/2016 16:08
Tags
SQL Server SQL

© 2016 - 2018 - IntermittentBug