How to Get SQL Server Build Numbers?

In this post, we will provide different ways to get SQL Server build numbers and its corresponding SQL Server update name to can determine what’s the latest cumulative update or service pack that has been installed on our SQL Server.

You might also like to read SQL Server: Get the Detailed Information Via SERVERPROPERTY


Get SQL Server Build Numbers

Here, we will provide four ways to get SQL Server Build Numbers / Versions.

(1) Using SQL Server Management Studio

  • Open SQL Management Studio > Connect To Server.
Connect to SQL Server.png

  • Right Click on Server Name > Properties.
SQL Server Properties.png

  • In General section > Check the Version field number.
Get SQL Server Build Numbers using SSMS
Get SQL Server Build Numbers using SSMS
Getting the current Cumulative Update - Service Pack installed - Get Version

(2) Using SQL Query

  • Again open SQL Server Management Studio > Connect to SQL Server.
  • Click on New Query  > Type the following query.
select @@version
SQL Server Versions by query

(3) Using the SQL Configuration Manager

  • Open SQL Server Configuration Manager.
Open SQL Server Configuration Manager
  • From right side > Open SQL Server Services.
  • Right click on SQL Server Instance name > Select Properties.
SQL Server Version via SQL Configuration wizard 1
  • Click on Advanced Tab > Scroll down to version field number.
SQL Server Version via SQL Configuration wizard
Detect the Current Cumulative Update / Service Pack

(4) Using PowerShell

You can use Windows PowerShell to invoke SQL command on a reachable server within the network using Invoke-Sqlcmd cmdlet as the following:

  • Open Windows PowerShell as Administrator
  • Type the Invoke-Sqlcmd with the below parameters.
    • -query: the SQL query that you need to run on the remote server.
    • -ServerInstance: the SQL server instance name.
    • -Username: the username that has sufficient permission to access and execute SQL query on the remote server.
    • -Password: The password of the elevated user.
  • Run Windows Power-Shell as Administrator.
  • Run the following command.
Invoke-Sqlcmd -query "select @@version" -ServerInstance epm\epmdb -Username sa -Password ****
SQL Server Versions by windows PowerShell
  • Make sure that you provide the correct SQL Server Instance to avoid the following error.
SQL Server Versions by windows PowerShell error.png
  • Make sure that you have elevated permission to can access SQL Server Instance.
SQL Server Versions by windows PowerShell error1.png

Get the current update installed in SQL Server

Once you got SQL Server build numbers for the current installed SQL Server, you can easily get the corresponding update name by doing the following:

SQL Server Build Number.png

Applies To

  • SQL Server 2017.
  • SQL Server 2016.
  • SQL Server 2014.
  • SQL Server 2012.

See Also

4 thoughts on “How to Get SQL Server Build Numbers?”

  1. Pingback: Extend SQL Server Trial Period more than once | SPGeeks

  2. Pingback: Extend SQL Server Evaluation Period | SPGeeks

Leave a Reply