Discontinued database engine functionality in SQL Server
SQL Server
Azure SQL Database
Azure Synapse Analytics (SQL DW)
Parallel 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)
SQL Server 2016 (13.x) is a 64-bit application. 32-bit installation is discontinued, though some elements run as 32-bit components.
Compatibility level 90 is discontinued. For more information, see ALTER DATABASE Compatibility Level (Transact-SQL).
ActiveX subsystem is discontinued. Use command line or PowerShell scripts instead.
Startup parameters -h and -g. For more information, see Database Engine Service Startup Options.
Secure Sockets Layer (SSL) encryption is discontinued. Use Transport Layer Security (TLS) instead. For more information, see Enable Encrypted Connections to the Database Engine.
Previous Versions
See also
- Deprecated database engine features in SQL Server 2019
- Deprecated database engine features in SQL Server 2017
- Deprecated database engine features in SQL Server 2016
- Breaking changes to database engine features in SQL Server 2019
- Breaking changes to database engine features in SQL Server 2017
- Breaking changes to database engine features in SQL Server 2016
- Deprecated features in SQL Server replication
Feedback
Loading feedback...