Skip to content

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

Latest commit

 

History

History
84 lines (67 loc) · 4.21 KB

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

File metadata and controls

84 lines (67 loc) · 4.21 KB
title Discontinued database engine functionality
description Learn which database engine functionality and features were discontinued in SQL Server 2019 (15.x), SQL Server 2016 (13.x), and previous versions.
ms.custom seo-lt-2019
ms.date 07/22/2020
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

Discontinued database engine functionality in SQL Server

[!INCLUDEsqlserver]

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

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

See also