TechNet
Export (0) Print
Expand All

Discontinued Database Engine Functionality in SQL Server 2014

 

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

The following table lists features that were removed in SQL Server 2014.

CategoryDiscontinued featureReplacement
Compatibility level90 compatibility levelDatabases must be set to at least compatibility level 100. When a database with a compatibility level of less than 100 is upgraded to SQL Server 2014, the compatibility level of the database is set to 100 during the upgrade operation.

The following table lists features that were removed in SQL Server 2012.

CategoryDiscontinued featureReplacement
Backup and RestoreBACKUP { DATABASE | LOG } WITH PASSWORD and BACKUP { DATABASE | LOG } WITH MEDIAPASSWORD are discontinued. RESTORE { DATABASE | LOG } WITH [MEDIA]PASSWORDcontinues to be deprecated.None
Backup and RestoreRESTORE { DATABASE | LOG } … WITH DBO_ONLYRESTORE { DATABASE | LOG } … … WITH RESTRICTED_USER
Compatibility level80 compatibility levelDatabases must be set to at least compatibility level 90.
Configuration Optionssp_configure 'user instance timeout' and 'user instances enabled'Use the Local Database feature. For more information, see SqlLocalDB Utility
Connection protocolsSupport for the VIA protocol is discontinued.Use TCP instead.
Database objectsWITH APPEND clause on triggersRe-create the whole trigger.
Database optionssp_dboptionALTER DATABASE
MailSQL MailUse Database Mail. For more information, see Database Mail and Use Database Mail Instead of SQL Mail.
Memory Management32-bit Address Windowing Extensions (AWE) and 32-bit Hot Add memory support.Use a 64-bit operating system.
MetadataDATABASEPROPERTYDATABASEPROPERTYEX
ProgrammabilitySQL Server Distributed Management Objects (SQL-DMO)SQL Server Management Objects (SMO)
Query hintsFASTFIRSTROW hintOPTION (FAST n ).
Remote serversThe 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.
Securitysp_dropaliasReplace aliases with a combination of user accounts and database roles. Use sp_dropalias to remove aliases in upgraded databases.
SecurityThe version parameter of PWDCOMPARE representing a value from a login earlier than SQL Server 2000 is discontinued.None
Service Broker programmability in SMOThe Microsoft.SqlServer.Management.Smo.Broker.BrokerPriority class no longer implements the Microsoft.SqlServer.Management.Smo.IObjectPermission interface.
SET optionsSET DISABLE_DEF_CNST_CHKNone.
System tablessys.database_principal_aliasesUse roles instead of aliases.
Transact-SQLRAISERROR in the format RAISERROR integer 'string' is discontinued.Rewrite the statement using the current RAISERROR(…) syntax.
Transact-SQL syntaxCOMPUTE / COMPUTE BYUse ROLLUP
Transact-SQL syntaxUse of *= and =*Use ANSI join syntax. For more information, see FROM (Transact-SQL).
XEventsdatabases_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

Deprecated Database Engine Features in SQL Server 2014

Show:
© 2016 Microsoft