discontinued-database-engine-functionality-in-sql-server.md

title	Discontinued database engine functionality
description	Learn which database engine functionality and features were discontinued in SQL Server.
author	MikeRayMSFT
ms.author	mikeray
ms.reviewer	randolphwest
ms.date	07/25/2022
ms.prod	sql
ms.technology	release-landing
ms.topic	conceptual
ms.custom	seo-lt-2019 event-tier1-build-2022
helpviewer_keywords	VIA protocol unsupported features [SQL Server] SQL Mail discontinued functionality [SQL Server] RESTORE WITH DBO_ONLY BACKUP WITH PASSWORD user instances enabled BACKUP WITH MEDIAPASSWORD AWE SQL-DMO *= and =* 80 compatibility levels COMPUTE BY user instance timeout sp_dropalias COMPUTE SSL WITH APPEND sys.database_principal_aliases sp_dboption DATABASEPROPERTY FASTFIRSTROW hint SET DISABLE_DEF_CNST_CHK
monikerRange	>= sql-server-linux-2017 || >= sql-server-2016

Discontinued Database Engine functionality in SQL Server

[!INCLUDEsqlserver]

This article describes the [!INCLUDEssDE] features that are no longer available in [!INCLUDEssnoversion].

Discontinued features in [!INCLUDEsssql22]

• The following Machine Learning Services packages are no longer included with installation of [!INCLUDE sssql22-md]. Instead, you can install any custom packages as desired. For more information, see What's new in SQL Server Machine Learning Services?

  Language	Package
  Python	microsoftml
  R	olapR
  R	sqlrutils
  R	MicrosoftML (R)

• SQL Server Big Data Clusters will be retired. See information in [[!INCLUDEbig-data-cluster] overview](../big-data-cluster/big-data-cluster-overview.md).

• SQL Server PolyBase scale-out groups will be retired. Scale out group functionality is removed from the product in [!INCLUDE sssql22-md]. PolyBase data virtualization continues to be fully supported as a scale-up feature in SQL Server. See Changes to PolyBase support in SQL Server.

Discontinued features in [!INCLUDEsssql19]

• 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 [!INCLUDEsssql14].

Discontinued features in [!INCLUDEsssql15-md]

• [!INCLUDEsssql15-md] 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

• Discontinued Database Engine Functionality in SQL Server 2014

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