| title | Discontinued Database Engine Functionality in SQL Server 2014 | Microsoft Docs | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | |||||||||||||||||||||||
| ms.date | 06/13/2017 | ||||||||||||||||||||||
| ms.prod | sql-server-2014 | ||||||||||||||||||||||
| ms.reviewer | |||||||||||||||||||||||
| ms.technology | release-landing | ||||||||||||||||||||||
| ms.topic | conceptual | ||||||||||||||||||||||
| helpviewer_keywords |
|
||||||||||||||||||||||
| ms.assetid | d686cdf0-d11d-4dba-9ec8-de1a5f189f25 | ||||||||||||||||||||||
| author | MikeRayMSFT | ||||||||||||||||||||||
| ms.author | mikeray | ||||||||||||||||||||||
| manager | craigg |
This topic describes the [!INCLUDEssDE] features that are no longer available in [!INCLUDEssCurrent].
Discontinued Features in [!INCLUDEssSQL14]
The following table lists features that were removed in [!INCLUDEssSQL14].
| Category | Discontinued feature | Replacement |
|---|---|---|
| Compatibility level | 90 compatibility level | Databases must be set to at least compatibility level 100. When a database with a compatibility level of less than 100 is upgraded to [!INCLUDEssSQL14], the compatibility level of the database is set to 100 during the upgrade operation. |
Discontinued Features in [!INCLUDEssSQL11]
The following table lists features that were removed in [!INCLUDEssSQL11].
| Category | Discontinued feature | Replacement |
|---|---|---|
| Backup and Restore | BACKUP { DATABASE | LOG } WITH PASSWORD and BACKUP { DATABASE | LOG } WITH MEDIAPASSWORD are discontinued. RESTORE { DATABASE | LOG } WITH [MEDIA]PASSWORDcontinues to be deprecated. | None |
| Backup and Restore | RESTORE { DATABASE | LOG } ... WITH DBO_ONLY | RESTORE { DATABASE | LOG } ... ... WITH RESTRICTED_USER |
| Compatibility level | 80 compatibility level | Databases must be set to at least compatibility level 90. |
| Configuration Options | sp_configure 'user instance timeout' and 'user instances enabled' |
Use the Local Database feature. For more information, see SqlLocalDB Utility |
| Connection protocols | Support for the VIA protocol is discontinued. | Use TCP instead. |
| Database objects | WITH APPEND clause on triggers |
Re-create the whole trigger. |
| Database options | sp_dboption |
ALTER DATABASE |
| SQL Mail | Use Database Mail. For more information, see Database Mail and Use Database Mail Instead of SQL Mail. | |
| Memory Management | 32-bit Address Windowing Extensions (AWE) and 32-bit Hot Add memory support. | Use a 64-bit operating system. |
| Metadata | DATABASEPROPERTY |
DATABASEPROPERTYEX |
| Programmability | SQL Server Distributed Management Objects (SQL-DMO) | SQL Server Management Objects (SMO) |
| Query hints | FASTFIRSTROW hint |
OPTION (FAST n ). |
| Remote servers | The ability for users to create new remote servers by using sp_addserver is discontinued. sp_addserver with the 'local' option remains available. Remote servers preserved during upgrade or created by replication can be used. |
Replace remote servers by using linked servers. |
| Security | sp_dropalias |
Replace aliases with a combination of user accounts and database roles. Use sp_dropalias to remove aliases in upgraded databases. |
| Security | The version parameter of PWDCOMPARE representing a value from a login earlier than [!INCLUDEssNoVersion] 2000 is discontinued. | None |
| Service Broker programmability in SMO | The Microsoft.SqlServer.Management.Smo.Broker.BrokerPriority class no longer implements the Microsoft.SqlServer.Management.Smo.IObjectPermission interface. | |
| SET options | SET DISABLE_DEF_CNST_CHK |
None. |
| System tables | sys.database_principal_aliases | Use roles instead of aliases. |
| Transact-SQL | RAISERROR in the format RAISERROR integer 'string' is discontinued. |
Rewrite the statement using the current RAISERROR(...) syntax. |
| Transact-SQL syntax | COMPUTE / COMPUTE BY |
Use ROLLUP |
| Transact-SQL syntax | Use of *= and =* | Use ANSI join syntax. For more information, see FROM (Transact-SQL). |
| XEvents | databases_data_file_size_changed, databases_log_file_size_changed eventdatabases_log_file_used_size_changed locks_lock_timeouts_greater_than_0 locks_lock_timeouts |
Replaced by database_file_size_change event, database_file_size_change database_file_size_change event lock_timeout_greater_than_0 lock_timeout |
Additional XEvent changes
resource_monitor_ring_buffer_record:
-
Fields removed: single_pages_kb, multiple_pages_kb
-
Fields added: target_kb, pages_kb
memory_node_oom_ring_buffer_recorded:
-
Fields removed: single_pages_kb, multiple_pages_kb
-
Fields added: target_kb, pages_kb