CPQ SQL Server Version

[SAPSupport]

Microsoft have several remarks on documentation with hints on feature removals, as the below example:

https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table?view=sql-server-ver16

Considering this can have impact on CPQ SQL queries being used, what is the current version of the SQL Server and what are the plans to cover this changes?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Current version is Microsoft SQL Azure - 12.0.2000.6 2022 Microsoft Corporation. This has the same level of compatibility as the legacy datacenters (MSSQL 2017).

Currently there are no plans to upgrade compatibility level, and when those plans are performed, these type of hints are always checked, along with status of each SQL query before moving.