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

title	Discontinued Database Engine Functionality in SQL Server 2016 | Microsoft Docs
ms.custom
ms.date	02/02/2017
ms.prod	sql
ms.prod_service	high-availability
ms.reviewer
ms.technology	release-landing
ms.topic	conceptual
helpviewer_keywords	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 WITH APPEND sys.database_principal_aliases sp_dboption DATABASEPROPERTY FASTFIRSTROW hint SET DISABLE_DEF_CNST_CHK
ms.assetid	d686cdf0-d11d-4dba-9ec8-de1a5f189f25
author	MikeRayMSFT
ms.author	mikeray

Discontinued Database Engine Functionality in SQL Server 2016

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]

This topic describes the [!INCLUDEssDE] features that are no longer available in [!INCLUDEssCurrent].

Discontinued Features in [!INCLUDEssSQL15]

• [!INCLUDEssSQL15] 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).

• ActiveX subsystem is discontinued. Use command line or PowerShell scripts instead.

• Startup parameters -h and -g. For more information, see Database Engine Service Startup Options.

Previous Versions

• Discontinued Database Engine Functionality in SQL Server 2014

See Also

Deprecated Database Engine Features in SQL Server 2016
Deprecated Features in SQL Server Replication