Discontinued database engine functionality in SQL Server

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

This topic describes the Database Engine features that are no longer available in SQL Server.

Discontinued features in SQL Server 2019 (15.x)

  • The following database scoped configuration options are discontinued:

    • DISABLE_BATCH_MODE_ADAPTIVE_JOIN
    • DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK
    • DISABLE_INTERLEAVED_EXECUTION_TVF

For current configuration options, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL).

Note

No features were discontinued in SQL Server 2017 (14.x).

Discontinued features in SQL Server 2016 (13.x)

Previous Versions

See also