Skip to content

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

Latest commit

 

History

History
110 lines (81 loc) · 5.96 KB

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

File metadata and controls

110 lines (81 loc) · 5.96 KB
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 10/18/2022
ms.service sql
ms.subservice 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
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.

  • Support for Hadoop (HDFS) external data sources will be retired for SQL Server PolyBase.

  • See Changes to PolyBase support in SQL Server.

  • Starting in [!INCLUDE sssql22-md], Hadoop external data sources are no longer supported. It is required to manually recreate external data sources previously created with TYPE = HADOOP, and any external table that uses this external data source. Users will also need to configure their external data sources to use new connectors when connecting to Azure Storage.

External Data Source From To
Azure Blob Storage wasb[s] abs
ADLS Gen 2 abfs[s] adls

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