Check version of SQL server

Recent posts

Create a Free SFTP Server with a PowerShell GUI on Windows05/10/2025
Setting up an SFTP server on Windows is often painful — you either need to work entirely from the… Read more: Create a Free SFTP Server with a PowerShell GUI on Windows
Export and Import All IIS Application Pools and Websites Between Servers05/10/2025
When migrating a Windows Server running IIS to a new machine, you can export all Application Pools and Websites… Read more: Export and Import All IIS Application Pools and Websites Between Servers
Check version of SQL server19/01/2025
To check the current version of a SQL server we have 3 diffrent ways 1º Open managemnt studio and… Read more: Check version of SQL server

Last updated on 19 January 2025

To check the current version of a SQL server we have 3 diffrent ways

1º Open managemnt studio and go to proprieties of instance, in genreral you have the year and version of the instance

3ºmake a query on the database. As we can see the image it says its sql server 2022
SELECT @@VERSION

3º via registry key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Name\Setup

References:
Link1: https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/
Link2: https://stackoverflow.com/questions/20042072/how-to-find-the-version-and-edition-of-sql-server-instance-via-registry

CATEGORIES:

DB|MS SQL

Tags:

No tags

Policy Terms