what SQL Server versions you are running

One issue that I am often faced with is determining the version of the database engine installed on SQL Server. In this tip we look at how to find the version of SQL Server that is running and also what service pack, hotfix, security update or cumulative update is installed.

How to tell what version of Microsoft SQL Server you are running?

  1. One simple way to do this is to run SELECT @@version
  2. Another option is to right click on the SQL Server instance name in SSMS and select Properties
  3. You can also use the SERVERPROPERTY function to get details about the version of SQL Server
  4. Check out all of the methods in this tip.
  5. SQL Server 2008 / 2008 R2 / 2012 / 2014 / 2016 / 2017 / 2019 / 2022

    This will look similar for all of these versions of SQL Server.

    SQL Server 2008 version information