Skip to content

Latest commit

 

History

History
44 lines (32 loc) · 2.52 KB

deprecated-database-engine-features-in-sql-server-2019.md

File metadata and controls

44 lines (32 loc) · 2.52 KB
title titleSuffix description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Deprecated Database Engine features
SQL Server 2019
Find out about deprecated Database Engine features that are still available in SQL Server 2019 (15.x), but shouldn't be used in new applications.
MikeRayMSFT
mikeray
randolphwest
07/09/2024
sql
release-landing
conceptual
deprecated changes 2019 [SQL Server]
>=sql-server-ver15 || >=sql-server-linux-ver15

Deprecated Database Engine features in SQL Server 2019 (15.x)

[!INCLUDE sqlserver2019]

[!INCLUDE sssql19-md] doesn't deprecate any features beyond features deprecated in prior releases:

Deprecation guidelines

When a feature is marked deprecated, it means:

  • The feature is in maintenance mode only. No new changes are added, including changes related to addressing interoperability with new features.
  • We strive not to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we might choose to permanently discontinue (remove) the feature from [!INCLUDE ssNoVersion] if it limits future innovations.
  • For new development work, don't use deprecated features. For existing applications, plan to modify applications that currently use these features as soon as possible.

You can monitor the use of deprecated features by using the [!INCLUDE ssNoVersion] Deprecated Features Object performance counter, or the deprecation_announcement and deprecation_final_support extended events. For more information, see Use SQL Server Objects.

Query deprecated features

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

[!INCLUDE deprecated-os-performance-counters]

Related content