What is deprecated in SQL Server 2016?

What is deprecated in SQL?

The SQLServer:Deprecated Features object in SQL Server provides a counter to monitor the features designated as deprecated. In each case the counter provides a usage count that lists the number of times the deprecated feature was encountered since SQL Server last started.

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 discontinued in SQL?

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

What is deprecated in SQL 2019?

A deprecated feature is no longer under active development, and it may be removed from a future version. If we are building something new, we should avoid using that feature on the expectation that it will be gone in the future.