Discontinued Database Engine Functionality in SQL Server 2016


Updated: February 2, 2017

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic describes the Database Engine features that are no longer available in SQL Server 2016.

  • SQL Server 2016 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.

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

Community Additions