Skip to content

Latest commit

 

History

History
47 lines (36 loc) · 2.58 KB

File metadata and controls

47 lines (36 loc) · 2.58 KB
description Deprecated database engine features in [!INCLUDE[sssql19-md](../includes/sssql19-md.md)]
title Deprecated database engine features in SQL Server 2019 | Microsoft Docs
titleSuffix SQL Server 2019
ms.custom seo-lt-2019
ms.date 02/12/2021
ms.prod sql
ms.prod_service high-availability
ms.reviewer
ms.technology release-landing
ms.topic conceptual
helpviewer_keywords
deprecated changes 2019 [SQL Server]
ms.assetid
author MikeRayMSFT
ms.author mikeray
monikerRange >=sql-server-ver15||>=sql-server-linux-ver15

Deprecated database engine features in SQL Server 2019 (15.x)

[!INCLUDEsqlserver2019]

The list of features deprecated in [!INCLUDE sssql19-md] is identical to the list of features deprecated in [[!INCLUDE sssql17-md]](deprecated-database-engine-features-in-sql-server-2017.md) and [[!INCLUDE sssql16-md]](deprecated-database-engine-features-in-sql-server-2016.md).

No additional features are deprecated in [!INCLUDE sssql19-md].

When a feature is marked deprecated, it means:

  • The feature is in maintenance mode only. No new changes will be done, including those related to inter-operability with new features.
  • We strive not to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we may choose to permanently remove the feature from [!INCLUDEssNoVersion] if it limits future innovations.
  • For new development work, we do not recommend using deprecated features.

You can monitor the use of deprecated features by using the [!INCLUDEssNoVersion] Deprecated Features Object performance counter and trace events. For more information, see Use SQL Server Objects.

The values of these counters are also available by executing the following statement:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name = 'SQLServer:Deprecated Features';

See Also