Is there a list of deprecated features in SQL Server?

What are some deprecated SQL features?

CategoryDeprecated featureFeature nameRemote servers@@remserverNoneRemote serversSET REMOTE_PROC_TRANSACTIONSSET REMOTE_PROC_TRANSACTIONSTable hintsHOLDLOCK table hint without parenthesis.HOLDLOCK table hint without parenthesis

What is deprecated in SQL 2019?

Deprecation guidelines 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 addressing inter-operability with new features. We strive not to remove a deprecated feature from future releases to make upgrades easier.

Is database mirroring deprecated in SQL Server 2019?

Unfortunately, this feature has been deprecated, but still, some organizations use database mirroring as a high availability solution. Database mirroring can be configured in SQL Server Standard edition. It supports manual failover and automatic failover using the witness server (High Safety with automatic failover).

What is discontinued in SQL?

Discontinued features in SQL Server 2016 (13. 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.