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

title	Discontinued Database Engine Functionality in SQL Server | Microsoft Docs
ms.custom
ms.date	02/02/2017
ms.prod	sql
ms.prod_service	high-availability
ms.reviewer
ms.technology	release-landing
ms.topic	conceptual
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
ms.assetid	d686cdf0-d11d-4dba-9ec8-de1a5f189f25
author	MikeRayMSFT
ms.author	mikeray
monikerRange	>= sql-server-linux-2017 || >= sql-server-2016 || = sqlallproducts-allversions

Discontinued database engine functionality in SQL Server

[!INCLUDEtsql-appliesto-ss-xxxx-xxxx-xxx-md]

This topic describes the [!INCLUDEssDE] features that are no longer available in [!INCLUDEssCurrent].

Discontinued features in [!INCLUDEssSQLv15]

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

Discontinued features in [!INCLUDEssSQL15]

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

• Discontinued Database Engine Functionality in SQL Server 2014

See Also

• Deprecated Database Engine Features in SQL Server 2016
• Deprecated Features in SQL Server Replication