What is the currently used SQL version for Azure SQL Databases?

Terry Friend 6 Reputation points
2020-12-18T14:55:07.527+00:00

I am building Azure SQL Databases and am wondering what is the "current stable version" of SQL being used?

Azure SQL Database
{count} vote

2 answers

Sort by: Most helpful
  1. Anurag Sharma 17,576 Reputation points
    2020-12-21T04:40:05.24+00:00

    Hi @Terry Friend , welcome to Microsoft Q&A.

    As correctly mentioned by @ErikEJ , Azure SQL Databases always run on latest stable version of the SQL Server database engine.(Refer to link for more details).

    You can run below queries to check the same after creating the database:

    select @@version as version;  
    
    select serverproperty('ProductVersion') as [version],serverproperty('Edition') as [edition];  
    
    SELECT name, compatibility_level FROM sys.databases;  
    

    Please let us know if more details needed.

    2 people found this answer helpful.

  2. ErikEJ 341 Reputation points MVP
    2020-12-18T18:11:19.457+00:00

    Azure SQL is "evergreen", and always run the latest version...

    1 person found this answer helpful.
    0 comments No comments