Home > Articles > Data

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Deprecated Features

In addition to the new and enhanced features in SQL Server 2012, it’s important to note the features for which support has been deprecated and discontinued. Table 2.1 lists the unsupported/deprecated features along with their replacements, if any.

TABLE 2.1 Deprecated and Discontinued Features in SQL Server 2012

Deprecated Feature

Replacement

SQL Server Profiler

Extended Events and the Extended Events GUI in SSMS

Sqlmaint.exe

None

Makepipe.exe and readpipe.exe commands

None

BACKUP { DATABASE | LOG } WITH PASSWORD and BACKUP { DATABASE | LOG } WITH MEDIAPASSWORD

None

RESTORE { DATABASE | LOG } ... WITH DBO_ONLY

RESTORE { DATABASE | LOG } ... ... WITH RESTRICTED_USER

SQL Mail

Database Mail

sp_dboption

ALTER DATABASE

80 compatibility level

Support provided only for compatibility levels 90 and higher

Database mirroring

AlwaysOn Availability Groups

sp_dropgroup, sp_helpgroup)

*= and =* OUTER JOIN syntax

LEFT OUTER JOIN or RIGHT OUTER JOIN

To help keep track of deprecated features so that you can identify potential future upgrade and compatibility problems, SQL Server 2012 provides the SQL Server: Deprecated Features performance counter and the Deprecation Announcement and Deprecation Final Support event classes, which you can monitor via SQL Server Profiler or SQL Trace.

  • + Share This
  • 🔖 Save To Your Account