How can I see my Sql Server database version on Azure Sql ?

Question

Hi,

since 2015 we are running an Azure Sql server and I need to know the Sql version. Like I saw on the support pages I run the next queries and I'm wondering if the Sql server version is really the SQL SERVER 2014 ?

It is there any way to see the database version from the Azure web console ?

Thank you.

select @@version as version; 
Microsoft SQL Azure (RTM) - 12.0.2000.8   Feb 17 2023 11:02:04   Copyright (C) 2022 Microsoft Corporation 

select serverproperty('ProductVersion') as [version],serverproperty('Edition') as [edition];
version    edition 12.0.2000.8    SQL Azure

version    edition 12.0.2000.8    SQL Azure

Answer 1

Hi Alin,

Welcome to Q&A Forum; this is a great place to get support, answers, and tips.

Thank you for posting your query; I'll be more than glad to help you out.

No worries, as your result states... it is Azure SQL 12 and not SQL Server 12 ;-) there is a difference. From my experience, they won't change the release number, but the date in that line changes... so your Azure SQL DB runs on a SQL version from February 2023.

Unfortunately, there is no official list of release numbers or dates that state which is the latest version (date).

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 2

Thanks for your question.

Just adding similar thread. Please have a look and also check comments.

https://learn.microsoft.com/en-us/answers/questions/203842/what-is-the-currently-used-sql-version-for-azure-s

Azure SQL Databases always run on latest stable version of the SQL Server database engine

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql