What are the possible ways to determine the deployed SQL Server version? I’ve tried to do it using the SQL Server software. I want to do it using a command line SQL statement. This page last updated March 22, 2018. SQL Server 2016 Versions: RTM (Release to Manufacturing) SQL Server 2016 – June 1, 2016 – version 13.0.1601.5.
By:|| Related Tips:||| > Problem One issue that I am often faced with is determining what service pack is installed on the SQL Server. In this tip we look at how to find the version of SQL Server that is running and also what service pack or hotfix is installed.
Solution There are a few ways to determine the version of SQL Server that is installed which we will cover in this tip. How to tell what version of SQL Server you are running? • One simple way to do this is to run SELECT @@version • Another option is to right click on the SQL Server instance name in SSMS and select Properties • You can also use the SERVERPROPERTY function to get details about the version of SQL Server • Check out all of the methods in this tip. Method 1 - to find SQL Server version The first is by using either Enterprise Manager or SQL Server Management Studio and right clicking on the instance name and selecting Properties. In the general section you will see information such as on the following screenshots. The 'Product version' or 'Version' gives you a number of the version that is installed.