- New SQL Server 2012 Features
- SQL Server 2012 Enhancements
- Deprecated Features
- Summary
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.