Discontinued database engine functionality in SQL Server

Applies to: yesSQL Server (all supported versions)

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.

  • precompute rank Server configuration option was discontinued beginning with SQL Server 2008. The article has been removed from documentation.

Previous Versions

See also