Skip to content

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

Latest commit

 

History

History
68 lines (56 loc) · 2.6 KB

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

File metadata and controls

68 lines (56 loc) · 2.6 KB
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.component database-engine
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
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
caps.latest.revision 100
author MikeRayMSFT
ms.author mikeray
manager craigg

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 subsytem is discontinued. Use command line or PowerShell scripts instead.

Previous Versions

See Also

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