SAP Knowledge Base Article - Preview

3648111 - SQL Server compatibility levels

Symptom

  • The user wants to know if Microsoft SQL Server 2022 'Enterprise Edition' supports compatibility level 130 for testing purposes.
  • The user inquires whether updating statistics is necessary when changing the compatibility level or not.
  • The user seeks clarification on whether the compatibility level change takes effect immediately.


Read more...

Environment

Microsoft SQL Server 20xx 'Enterprise Edition' in SAP NetWeaver Products

Product

SAP enhancement package for SAP ERP all versions

Keywords

sql server compatibility level, sql server 2016, sql server 2022, compatibility level 130, compatibility level 160, upgrading compatibility level, alter database, sap netweaver, database migration, query optimization, plan cache, updating statistics, sql server best practices , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.