Lesson Learned #28: Why does SQL SERVER Management Studio report that my Azure SQL Database version is 12?
First published on MSDN on Aug 07, 2017 Very often, our customers are asking about why does SQL Server Management Studio report that my Azure SQL Database versions is 12? Does it mean that I'm using SQL SERVER 2014? Why does it mean that is not updated?The explaination is that if your application check the version of SQL using select @@version the information reported will be wrong, because, right now, to identify the version of Azure SQL Database, we use the combination of edition and ProjectMayorVersion ( select SERVERPROPERTY('edition'), select SERVERPROPERTY('ProductMajorVersion').
