Skip to content

Latest commit

 

History

History
118 lines (86 loc) · 6.91 KB

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

File metadata and controls

118 lines (86 loc) · 6.91 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Discontinued database engine functionality
Learn which database engine functionality and features were discontinued in SQL Server.
MikeRayMSFT
mikeray
randolphwest
07/09/2024
sql
release-landing
conceptual
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
>=sql-server-linux-2017 || >=sql-server-2016

Discontinued Database Engine functionality in SQL Server

[!INCLUDE sqlserver]

This article describes the [!INCLUDE ssDE] features that are no longer available in [!INCLUDE ssnoversion].

Discontinued features in SQL Server 2022 (16.x)

  • 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 (Python package in SQL Server Machine Learning Services)
    R olapR (R package in SQL Server Machine Learning Services)
    R sqlrutils (R package in SQL Server Machine Learning Services)
    R MicrosoftML (R package in SQL Server Machine Learning Services)

  • SQL Server Big Data Clusters will be retired. See information in Introducing SQL Server Big Data Clusters.

  • [!INCLUDE ssnoversion-md] 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 [!INCLUDE ssnoversion-md].

  • Support for Hadoop (HDFS) external data sources will be retired for [!INCLUDE ssnoversion-md] PolyBase.

  • See Changes to PolyBase support in SQL Server.

  • In [!INCLUDE sssql22-md] and later versions, Hadoop external data sources are no longer supported. You must manually recreate external data sources previously created with TYPE = HADOOP, and any external table that uses this external data source. You must also configure your 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

  • In July 2024, Stretch Database was discontinued in all supported versions of [!INCLUDE ssnoversion-md].

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.

In July 2024, Stretch Database was discontinued in all supported versions of [!INCLUDE ssnoversion-md].

Discontinued features in SQL Server 2017 (14.x)

In July 2024, Stretch Database was discontinued in all supported versions of [!INCLUDE ssnoversion-md].

No other features were discontinued in [!INCLUDE sssql14].

Discontinued features in SQL Server 2016 (13.x)

Previous versions

Related content