Skip to main content
Discontinued Management Tools Features in SQL Server 2016

This topic describes SQL Server Management Tools features that are no longer available in SQL Server.

Features Removed in SQL Server 2012

SQL Server Compact Edition

The SQL Server Compact Edition code editor has been removed from SQL Server Management Studio. Support for SQL Server Compact Edition has also been removed from Object Explorer, Solution Explorer, and Template Explorer. Use the Transact-SQL editors in Microsoft Visual Studio 2010 Service Pack 1 or Webmatrix instead.

ActiveX Subsystem for SQL Server Agent

The ActiveX subsystem for SQL Server Agent has been removed in this release. There is no replacement functionality.

sp_addtask, sp_deletetask, sp_updatetask

Sp_addtask, sp_deletetask, and sp_updatetask have been removed in this release. Do not use this functionality in new or updated applications.

Net Send and Pager Notification

Net Send and Pager Notification have been removed in this release. Do not use this functionality in new or updated applications.

Data-tier Applications

Some data-tier application (DAC) features present in SQL Server 2008 R2 have been removed in SQL Server 2012. However, the Data-Tier Application Framework (DACfx version 3.0) released with SQL Server 2012 is compatible with SQL Server 2005 through SQL Server 2012 and Azure SQL Database. DAC version 3.0 is not supported by earlier versions of Management Studio including Management Studio in SQL Server 2008 R2. Visual Studio 2010 Database Projects do not support DAC 3.0 DACPAC packages or DAC Export (BACPAC) packages generated with DACfx version 3.0 or later.

Microsoft recommends using the latest available version SQL Server Data Tools Database Projects.

DACfx 3.0 API and SQL Server tools do support reading DACPAC and BACPAC files created using earlier SQL Server tools and DACfx versions: extracting databases into DACPAC files from these versions, and deploying databases into supported versions of SQL Server through Management Studio or SQL Server Data Tools.

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?