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.

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 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.

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]PASSWORD continues 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

Mail

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 SQL Server 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

Community Additions

ADD
Show:
© 2014 Microsoft