--- title: Deprecated Database Engine Features titleSuffix: SQL Server 2017 description: Find out about deprecated Database Engine features that are still available in SQL Server 2017 (14.x), but shouldn't be used in new applications. author: MikeRayMSFT ms.author: mikeray ms.reviewer: randolphwest ms.date: 11/18/2025 ms.service: sql ms.subservice: release-landing ms.topic: release-notes ms.custom: - ignite-2025 helpviewer_keywords: - "deprecated features [SQL Server]" - "Database Engine [SQL Server], backward compatibility" - "deprecation [SQL Server], feature list" monikerRange: ">=sql-server-2017 || >=sql-server-linux-2017" --- # Deprecated Database Engine features in SQL Server 2017 (14.x) [!INCLUDE [SQL Server 2017](../includes/applies-to-version/sqlserver2017.md)] [!INCLUDE [sssql17-md](../includes/sssql17-md.md)] deprecates: - Data Quality Services (DQS) - Master Data Services (MDS) Features that were deprecated in prior releases are also deprecated in [!INCLUDE [sssql17-md](../includes/sssql17-md.md)]. For information about deprecated features in other versions of [!INCLUDE [ssnoversion-md](../includes/ssnoversion-md.md)], see: - [Deprecated Database Engine features in SQL Server 2025 (17.x)](deprecated-database-engine-features-in-sql-server-2025.md) - [Deprecated Database Engine features in SQL Server 2022 (16.x)](deprecated-database-engine-features-in-sql-server-2022.md) - [Deprecated Database Engine features in SQL Server 2019 (15.x)](deprecated-database-engine-features-in-sql-server-2019.md) - [Deprecated Database Engine features in SQL Server 2016 (13.x)](deprecated-database-engine-features-in-sql-server-2016.md) ## Deprecation guidelines This article describes the deprecated [!INCLUDE [ssDEnoversion](../includes/ssdenoversion-md.md)] features that are still available in [!INCLUDE [sssql17-md](../includes/sssql17-md.md)]. Deprecated features shouldn't be used in new applications. When a feature is marked deprecated, it means: - The feature is in maintenance mode only. No new changes are added, including changes related to addressing interoperability with new features. - We strive not to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we might choose to permanently discontinue (remove) the feature from [!INCLUDE [ssNoVersion](../includes/ssnoversion-md.md)] if it limits future innovations. - For new development work, don't use deprecated features. For existing applications, plan to modify applications that currently use these features as soon as possible. You can monitor the use of deprecated features by using the [!INCLUDE [ssNoVersion](../includes/ssnoversion-md.md)] Deprecated Features Object performance counter and trace events. For more information, see [Use SQL Server Objects](../relational-databases/performance-monitor/use-sql-server-objects.md). The values of these counters are also available by executing the following statement: [!INCLUDE [deprecated-os-performance-counters](../includes/deprecated-os-performance-counters.md)] > [!NOTE] > This list is identical to the [!INCLUDE [sssql15-md](../includes/sssql16-md.md)] list. There are no new deprecated or discontinued Database Engine features announced for [!INCLUDE [sssql17-md](../includes/sssql17-md.md)]. ## Features deprecated in the next version of SQL Server The following [!INCLUDE [ssDEnoversion](../includes/ssdenoversion-md.md)] features won't be supported in a future version of [!INCLUDE [ssNoVersion](../includes/ssnoversion-md.md)]. Don't use these features in new development work, and modify applications that currently use these features as soon as possible. The **Feature name** value appears in trace events as the ObjectName and in performance counters and `sys.dm_os_performance_counters` as the instance name. The **Feature ID** value appears in trace events as the ObjectId. ### Back up and restore | Deprecated feature | Replacement | Feature name | Feature ID | | --- | --- | --- | --- | | `RESTORE` { `DATABASE` | `LOG` } `WITH` [MEDIA]`PASSWORD` continues to be deprecated.

`BACKUP` { `DATABASE` | `LOG` } `WITH PASSWORD` and `BACKUP` { `DATABASE` | `LOG` } `WITH MEDIAPASSWORD` are discontinued. | None. | `BACKUP DATABASE` or `BACKUP LOG WITH PASSWORD`

`BACKUP DATABASE` or `BACKUP LOG WITH MEDIAPASSWORD` | 104

103 | ### Compatibility levels | Deprecated feature | Replacement | Feature name | Feature ID | | --- | --- | --- | --- | | Upgrade from version 100 ([!INCLUDE [sql2008-md](../includes/sql2008-md.md)] and [!INCLUDE [sql2008r2](../includes/sql2008r2-md.md)]). | When a [!INCLUDE [ssNoVersion](../includes/ssnoversion-md.md)] version goes out of [support](/lifecycle/products/?products=sql-server), the associated database compatibility levels are marked deprecated. However, we continue to support applications certified on any supported database compatibility level as long as possible, to make the upgrades easier. For more information about compatibility levels, see [ALTER DATABASE (Transact-SQL) compatibility level](../t-sql/statements/alter-database-transact-sql-compatibility-level.md). | Database compatibility level 100 | 108 | ### Database objects | Deprecated feature | Replacement | Feature name | Feature ID | | --- | --- | --- | --- | | Ability to return result sets from triggers | None | Returning results from trigger | 12 | ### Encryption | Deprecated feature | Replacement | Feature name | Feature ID | | --- | --- | --- | --- | | Encryption using RC4 or RC4_128 is deprecated and is scheduled to be removed in the next version. Decrypting RC4 and RC4_128 aren't deprecated. | Use another encryption algorithm such as AES. | Deprecated encryption algorithm | 253 | | Using the MD2, MD4, MD5, SHA, and SHA1 is deprecated. | Use SHA2_256 or SHA2_512 instead. Older algorithms continue working, but they raise a deprecation event. | Deprecated hash algorithm | None | ### Remote servers | Deprecated feature | Replacement | Feature name | Feature ID | | --- | --- | --- | --- | | `sp_addremotelogin`

`sp_addserver`

`sp_dropremotelogin`

`sp_helpremotelogin`

`sp_remoteoption` | Replace remote servers by using linked servers. `sp_addserver` can only be used with the local option. | `sp_addremotelogin`

`sp_addserver`

`sp_dropremotelogin`

`sp_helpremotelogin`

`sp_remoteoption` | 70

69

71

72

73 | | @@remserver | Replace remote servers by using linked servers. | None | None | | `SET REMOTE_PROC_TRANSACTIONS` | Replace remote servers by using linked servers. | `SET REMOTE_PROC_TRANSACTIONS` | 110 | ### Transact-SQL | Deprecated feature | Replacement | Feature name | Feature ID | | --- | --- | --- | --- | | `SET ROWCOUNT` for `INSERT`, `UPDATE`, and `DELETE` statements | `TOP` keyword | `SET ROWCOUNT` | 109 | | HOLDLOCK table hint without parenthesis. | Use HOLDLOCK with parenthesis. | HOLDLOCK table hint without parenthesis | 167 | ## Features deprecated in a future version of SQL Server The following SQL Server Database Engine features are supported in the next version of SQL Server. The specific version of SQL Server hasn't been determined. ### Back up and restore | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | BACKUP { DATABASE | LOG } TO TAPE

BACKUP { DATABASE | LOG } TO *device_that_is_a_tape* | BACKUP { DATABASE | LOG } TO DISK

BACKUP { DATABASE | LOG } TO *device_that_is_a_disk* | BACKUP DATABASE or LOG TO TAPE | | `sp_addumpdevice 'tape'` | `sp_addumpdevice 'disk'` | `ADDING TAPE DEVICE` | | `sp_helpdevice` | `sys.backup_devices` | `sp_helpdevice` | ### Compatibility levels | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_dbcmptlevel` | `ALTER DATABASE` ... `SET COMPATIBILITY_LEVEL`. For more information, see [ALTER DATABASE (Transact-SQL) compatibility level](../t-sql/statements/alter-database-transact-sql-compatibility-level.md). | `sp_dbcmptlevel` | | Database compatibility level 110 and 120. | Plan to upgrade the database and application for a future release. However, we continue to support applications certified on any supported database compatibility level as long as possible, to make the upgrades easier. For more information about compatibility levels, see [ALTER DATABASE (Transact-SQL) compatibility level](../t-sql/statements/alter-database-transact-sql-compatibility-level.md). | Database compatibility level 110

Database compatibility level 120 | ### Collations | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | Korean_Wansung_Unicode

Lithuanian_Classic

SQL_AltDiction_CP1253_CS_AS | None. These collations exist in SQL Server 2005 (9.x), but aren't visible through fn_helpcollations. | Korean_Wansung_Unicode

Lithuanian_Classic

SQL_AltDiction_CP1253_CS_AS | | Hindi

Macedonian | These collations exist in SQL Server 2005 (9.x) and higher, but aren't visible through fn_helpcollations. Use Macedonian_FYROM_90 and Indic_General_90 instead. | Hindi

Macedonian | | Azeri_Latin_90

Azeri_Cyrilllic_90 | Azeri_Latin_100

Azeri_Cyrilllic_100 | Azeri_Latin_90

Azeri_Cyrilllic_90 | ### Data types | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_addtype`

`sp_droptype` | `CREATE TYPE`

`DROP TYPE` | `sp_addtype`

sp_droptype | | **timestamp** syntax for **rowversion** data type | **rowversion** data type syntax | `TIMESTAMP` | | Ability to insert null values into **timestamp** columns. | Use a `DEFAULT` instead. | `INSERT NULL` into `TIMESTAMP` columns | | 'text in row' table option | Use **varchar(max)**, **nvarchar(max)**, and **varbinary(max)** data types. For more information, see [sp_tableoption](../relational-databases/system-stored-procedures/sp-tableoption-transact-sql.md). | Text in row table option | | Data types:

**text**

**ntext**

**image** | Use **varchar(max)**, **nvarchar(max)**, and **varbinary(max)** data types. | Data types: **text**, **ntext**, or **image** | ### Database management | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_attach_db`

`sp_attach_single_file_db` | `CREATE DATABASE` statement with the `FOR ATTACH` option. To rebuild multiple log files, when one or more have a new location, use the `FOR ATTACH_REBUILD_LOG` option. | `sp_attach_db`

`sp_attach_single_file_db` | | `sp_certify_removable`

`sp_create_removable` | `sp_detach_db` | `sp_certify_removable`

`sp_create_removable` | | `sp_dbremove` | `DROP DATABASE` | `sp_dbremove` | | `sp_renamedb` | `MODIFY NAME` in `ALTER DATABASE` | sp_renamedb | ### Database objects | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `CREATE DEFAULT`

`DROP DEFAULT`

`sp_bindefault`

sp_unbindefault | `DEFAULT` keyword in `CREATE TABLE` and `ALTER TABLE` | CREATE_DROP_DEFAULT

`sp_bindefault`

`sp_unbindefault` | | `CREATE RULE`

`DROP RULE`

sp_bindrule

`sp_unbindrule` | `CHECK` keyword in `CREATE TABLE` and `ALTER TABLE` | CREATE_DROP_RULE

`sp_bindrule`

`sp_unbindrule` | | `sp_change_users_login` | Use `ALTER USER`. | `sp_change_users_login` | | `sp_depends` | `sys.dm_sql_referencing_entities` and `sys.dm_sql_referenced_entities` | `sp_depends` | | `sp_getbindtoken` | Use MARS or distributed transactions. | `sp_getbindtoken` | ### Database options | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_bindsession` | Use MARS or distributed transactions. | `sp_bindsession` | | `sp_resetstatus` | `ALTER DATABASE SET` { `ONLINE` | `EMERGENCY` } | sp_resetstatus | | `TORN_PAGE_DETECTION` option of `ALTER DATABASE` | `PAGE_VERIFY TORN_PAGE_DETECTION` option of `ALTER DATABASE` | `ALTER DATABASE WITH TORN_PAGE_DETECTION` | ### DBCC | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | DBCC DBREINDEX | `REBUILD` option of `ALTER INDEX`. | DBCC DBREINDEX | | DBCC INDEXDEFRAG | `REORGANIZE` option of `ALTER INDEX` | DBCC INDEXDEFRAG | | DBCC SHOWCONTIG | `sys.dm_db_index_physical_stats` | DBCC SHOWCONTIG | | DBCC PINTABLE

DBCC UNPINTABLE | Has no effect. | DBCC [UN]PINTABLE | ### Extended properties | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | Level0type = 'type' and Level0type = 'USER' to add extended properties to level-1 or level-2 type objects. | Use Level0type = 'USER' only to add an extended property directly to a user or role.

Use Level0type = '`SCHEMA`' to add an extended property to level-1 types such as `TABLE` or VIEW, or level-2 types such as COLUMN or TRIGGER. For more information, see [sp_addextendedproperty](../relational-databases/system-stored-procedures/sp-addextendedproperty-transact-sql.md). | EXTPROP_LEVEL0`TYPE`

EXTPROP_LEVEL0USER | ### Extended stored procedures | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `xp_grantlogin`

`xp_revokelogin`

`xp_loginConfig` | Use `CREATE LOGIN`

Use `DROP LOGIN IsIntegratedSecurityOnly` argument of `SERVERPROPERTY` | `xp_grantlogin`

`xp_revokelogin`

xp_loginconfig | ### Extended stored procedures programming | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | srv_alloc

srv_convert

srv_describe

srv_getbindtoken

srv_got_attention

srv_message_handler

srv_paramdata

srv_paraminfo

srv_paramlen

srv_parammaxlen

srv_paramname

srv_paramnumber

srv_paramset

srv_paramsetoutput

srv_paramstatus

srv_paramtype

srv_pfield

srv_pfieldex

srv_rpcdb

srv_rpcname

srv_rpcnumber

srv_rpcoptions

srv_rpcowner

srv_rpcparams

srv_senddone

srv_sendmsg

srv_sendrow

srv_setcoldata

srv_setcollen

srv_setutype

srv_willconvert

srv_wsendmsg | Use CLR Integration instead. | `XP_API` | | `sp_addextendedproc`

`sp_dropextendedproc`

`sp_helpextendedproc` | Use CLR Integration instead. | `sp_addextendedproc`

`sp_dropextendedproc`

`sp_helpextendedproc` | | `xp_grantlogin`

`xp_revokelogin`

`xp_loginConfig` | Use `CREATE LOGIN`

Use `DROP LOGIN IsIntegratedSecurityOnly` argument of `SERVERPROPERTY` | `xp_grantlogin`

`xp_revokelogin`

xp_loginconfig | ### High availability | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | database mirroring | Always On availability groups

If your edition of SQL Server doesn't support Always On availability groups, use log shipping. | DATABASE_MIRRORING | ### Index options | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_indexoption` | `ALTER INDEX` | `sp_indexoption` | | `CREATE TABLE`, `ALTER TABLE`, or `CREATE INDEX` syntax without parentheses around the options. | Rewrite the statement to use the current syntax. | INDEX_OPTION | ### Instance options | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_configure` option 'allow updates' | System tables are no longer updatable. Setting has no effect. | `sp_configure` 'allow updates' | | `sp_configure` options:

'locks'

'open objects'

'set working set size' | Now automatically configured. Setting has no effect. | `sp_configure` 'locks'

`sp_configure` 'open objects'

`sp_configure` 'set working set size' | | `sp_configure` option 'priority boost' | System tables are no longer updatable. Setting has no effect. Use the Windows start /high ... program.exe option instead. | `sp_configure` 'priority boost' | | `sp_configure` option 'remote proc trans' | System tables are no longer updatable. Setting has no effect. | `sp_configure` 'remote proc trans' | ### Linked servers | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | Specifying the SQLOLEDB provider for linked servers. | [Microsoft OLE DB Driver for SQL Server](../connect/oledb/oledb-driver-for-sql-server.md) | SQLOLEDB for linked servers | ### Metadata | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | FILE_ID

INDEXKEY_PROPERTY | FILE_IDEX

`sys.index_columns` | FILE_ID

INDEXKEY_PROPERTY | ### Native XML Web Services | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | The `CREATE ENDPOINT` or `ALTER ENDPOINT` statement with the `FOR SOAP` option.

sys.endpoint_webmethods

`sys.soap_endpoints` | Use Windows Communications Foundation (WCF) or ASP.NET instead. | `CREATE`/`ALTER ENDPOINT`

`sys.endpoint_webmethods`

EXT_soap_endpoints

`sys.soap_endpoints` | ### Other | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | DB-Library

Embedded SQL for C | Although the Database Engine still supports connections from existing applications that use the DB-Library and Embedded SQL APIs, it doesn't include the files or documentation required to do programming work on applications that use these APIs. A future version of the SQL Server Database Engine drops support for connections from DB-Library or Embedded SQL applications. Don't use DB-Library or Embedded SQL to develop new applications. Remove any dependencies on either DB-Library or Embedded SQL when you're modifying existing applications. Instead of these APIs, use the SQLClient namespace or an API such as ODBC. SQL Server 2019 (15.x) doesn't include the DB-Library DLL required to run these applications. To run DB-Library or Embedded SQL applications, you must have available the DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL Server 2000 (8.x). | None | ### Security | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | The `ALTER LOGIN WITH SET CREDENTIAL` syntax | Replaced by the new `ALTER LOGIN ADD` and `DROP CREDENTIAL` syntax | `ALTER LOGIN WITH SET CREDENTIAL` | | `sp_addapprole`

`sp_dropapprole` | `CREATE APPLICATION ROLE`

`DROP APPLICATION ROLE` | `sp_addapprole`

sp_dropapprole | | `sp_addlogin`

`sp_droplogin` | `CREATE LOGIN`

`DROP LOGIN` | `sp_addlogin`

sp_droplogin | | `sp_adduser`

`sp_dropuser` | `CREATE USER`

`DROP USER` | `sp_adduser`

`sp_dropuser` | | `sp_grantdbaccess`

`sp_revokedbaccess` | `CREATE USER`

`DROP USER` | `sp_grantdbaccess`

`sp_revokedbaccess` | | `sp_addrole`

`sp_droprole` | `CREATE ROLE`

`DROP ROLE` | `sp_addrole`

sp_droprole | | `sp_approlepassword`

`sp_password` | `ALTER APPLICATION ROLE`

`ALTER LOGIN` | `sp_approlepassword`

`sp_password` | | `sp_changedbowner` | `ALTER AUTHORIZATION` | `sp_changedbowner` | | `sp_changeobjectowner` | `ALTER SCHEMA` or `ALTER AUTHORIZATION` | `sp_changeobjectowner` | | `sp_control_dbmasterkey_password` | A master key must exist and password must be correct. | `sp_control_dbmasterkey_password` | | `sp_defaultdb`

`sp_defaultlanguage` | `ALTER LOGIN` | `sp_defaultdb`

`sp_defaultlanguage` | | `sp_denylogin`

`sp_grantlogin`

`sp_revokelogin` | `ALTER LOGIN DISABLE`

`CREATE LOGIN`

`DROP LOGIN` | `sp_denylogin`

`sp_grantlogin`

sp_revokelogin | | USER_ID | DATABASE_PRINCIPAL_ID | USER_ID | | `sp_srvrolepermission`

`sp_dbfixedrolepermission` | These stored procedures return information that was correct in [!INCLUDE [ssVersion2000](../includes/ssversion2000-md.md)]. The output doesn't reflect changes to the permissions hierarchy implemented in SQL Server 2008. For more information, see [Permissions of Fixed Server Roles](/previous-versions/sql/sql-server-2008/ms175892(v=sql.100)). | `sp_srvrolepermission`

`sp_dbfixedrolepermission` | | `GRANT ALL`

`DENY ALL`

`REVOKE ALL` | `GRANT`, `DENY`, and `REVOKE`-specific permissions. | ALL Permission | | PERMISSIONS intrinsic function | Query `sys.fn_my_permissions` instead. | PERMISSIONS | | SETUSER | `EXECUTE AS` | SETUSER | | RC4 and `DESX` encryption algorithms | Use another algorithm such as AES. | `DESX` algorithm | ### Server Configuration Options | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | c2 audit option default trace enabled option

default trace enabled option | [common criteria compliance enabled Server Configuration Option](configure-windows/common-criteria-compliance-enabled-server-configuration-option.md)

[Extended Events overview](../relational-databases/extended-events/extended-events.md) | `sp_configure` 'c2 audit mode'

`sp_configure` 'default trace enabled' | ### SMO classes | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | *Microsoft.SQLServer. Management.Smo.Information* class

*Microsoft.SQLServer. Management.Smo.Settings* class

*Microsoft.SQLServer.Management. Smo.DatabaseOptions* class

*Microsoft.SqlServer.Management.Smo. DatabaseDdlTrigger.NotForReplication* property | *Microsoft.SqlServer. Management.Smo.Server* class

**Microsoft.SqlServer. Management.Smo.Server* class

*Microsoft.SqlServer. Management.Smo.Database* class

None | None | ### SQL Server Agent | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | **net send** notification

Pager notification | E-mail notification

E-mail notification | None | ### SQL Server Management Studio | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | Solution Explorer integration in SQL Server Management Studio | | None | ### System stored procedures and functions | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_db_increased_partitions` | None. Support for increased partitions is available by default in SQL Server 2019 (15.x). | `sp_db_increased_partitions` | | fn_virtualservernodes

fn_servershareddrives | `sys.dm_os_cluster_nodes`

`sys.dm_io_cluster_shared_drives` | fn_virtualservernodes

fn_servershareddrives | | fn_get_sql | `sys.dm_exec_sql_text` | fn_get_sql | | `sp_lock` | `sys.dm_tran_locks` | `sp_lock` | ### System tables | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | sysaltfiles

syscacheobjects

syscolumns

syscomments

sysconfigures

sysconstraints

syscurconfigs

sysdatabases

sysdepends

sysdevices

sysfilegroups

sysfiles

sysforeignkeys

sysfulltextcatalogs

sysindexes

sysindexkeys

syslockinfo

syslogins

sysmembers

sysmessages

sysobjects

sysoledbusers

sysopentapes

sysperfinfo

syspermissions

sysprocesses

sysprotects

sysreferences

sysremotelogins

sysservers

systypes

sysusers | Compatibility views. For more information, see [System Compatibility Views](../relational-databases/system-compatibility-views/system-compatibility-views-transact-sql.md).

**Important:** The compatibility views don't expose metadata for features that were introduced in SQL Server 2005 (9.x). We recommend that you upgrade your applications to use catalog views. For more information, see [System catalog views](../relational-databases/system-catalog-views/catalog-views-transact-sql.md). | sysaltfiles

syscacheobjects

syscolumns

syscomments

sysconfigures

sysconstraints

syscurconfigs

sysdatabases

sysdepends

sysdevices

sysfilegroups

sysfiles

sysforeignkeys

sysfulltextcatalogs

sysindexes

sysindexkeys

syslockinfo

syslogins

sysmembers

sysmessages

sysobjects

sysoledbusers

sysopentapes

sysperfinfo

syspermissions

sysprocesses

sysprotects

sysreferences

sysremotelogins

sysservers

systypes

sysusers | | `sys.numbered_procedures`

`sys.numbered_procedure_parameters` | None | numbered_procedures

numbered_procedure_parameters | ### SQL Trace stored procedures, functions, and catalog views | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sp_trace_create`

`sp_trace_setevent`

`sp_trace_setfilter`

`sp_trace_setstatus`

fn_trace_geteventinfo

fn_trace_getfilterinfo

fn_trace_getinfo

fn_trace_gettable

`sys.traces`

`sys.trace_events`

`sys.trace_event_bindings`

sys.trace_categories

sys.trace_columns

sys.trace_subclass_values | [Extended Events overview](../relational-databases/extended-events/extended-events.md) | `sp_trace_create`

`sp_trace_setevent`

`sp_trace_setfilter`

`sp_trace_setstatus`

fn_trace_geteventinfo

fn_trace_getfilterinfo

fn_trace_getinfo

fn_trace_gettable

`sys.traces`

`sys.trace_events`

`sys.trace_event_bindings`

`sys.trace_categories`

`sys.trace_columns`

`sys.trace_subclass_values` | ### System views | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `sys.sql_dependencies` | `sys.sql_expression_dependencies` | `sys.sql_dependencies` | ### Table compression | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | The use of the vardecimal storage format. | Vardecimal storage format is deprecated. SQL Server 2019 (15.x) data compression, compresses decimal values, and other data types. We recommend that you use data compression instead of the vardecimal storage format. | Vardecimal storage format | | Use of the `sp_db_vardecimal_storage_format` procedure. | Vardecimal storage format is deprecated. SQL Server 2019 (15.x) data compression, compresses decimal values as well as other data types. We recommend that you use data compression instead of the vardecimal storage format. | `sp_db_vardecimal_storage_format` | | Use of the `sp_estimated_rowsize_reduction_for_vardecimal` procedure. | Use data compression and the `sp_estimate_data_compression_savings` procedure instead. | `sp_estimated_rowsize_reduction_for_vardecimal` | ### Text pointers | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | WRITETEXT

UPDATETEXT

READTEXT | None | UPDATETEXT or WRITETEXT

READTEXT | | TEXTPTR()

TEXTVALID() | None | TEXTPTR

TEXTVALID | ### Transact-SQL | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | `::` function-calling sequence | Replaced by `SELECT FROM sys.()`.

For example, replace `SELECT * FROM ::fn_virtualfilestats(2,1)`with `SELECT * FROM sys.fn_virtualfilestats(2,1)`. | '::' function calling syntax | | Three-part and four-part column references. | Two-part names are the standard-compliant behavior. | More than two-part column name | | A string enclosed in quotation marks used as a column alias for an expression in a `SELECT` list:

'*string_alias*' = *expression* | *expression* [AS] *column_alias*

*expression* [AS] [*column_alias*]

*expression* [AS] "*column_alias*"

*expression* [AS] '*column_alias*'

*column_alias* = *expression* | String literals as column aliases | | Numbered procedures | None. Don't use. | ProcNums | | *table_name.index_name* syntax in `DROP INDEX` | ` ON ` syntax in `DROP INDEX`. | `DROP INDEX` with two-part name | | Not ending Transact-SQL statements with a semicolon. | End Transact-SQL statements with a semicolon (`;`). | None | | `GROUP BY ALL` | Use custom case-by-case solution with `UNION` or derived table. | `GROUP BY ALL` | | `ROWGUIDCOL` as a column name in DML statements. | Use $rowguid. | `ROWGUIDCOL` | | IDENTITYCOL as a column name in DML statements. | Use $identity. | IDENTITYCOL | | Use of #, ## as temporary table and temporary stored procedure names. | Use at least one additional character. | '#' and '##' as the name of temporary tables and stored procedures | | Use of @, or @@ as Transact-SQL identifiers. | Don't use @ or @@ or names that begin with @@ as identifiers. | '@' and names that start with '@@' as Transact-SQL identifiers | | Use of `DEFAULT` keyword as default value. | Don't use the word `DEFAULT` as a default value. | `DEFAULT` keyword as a default value | | Use of a space as a separator between table hints. | Use a comma to separate table hints. | Multiple table hints without comma | | The select list of an aggregate indexed view must contain COUNT_BIG (\*) in 90 compatibility mode | Use COUNT_BIG (\*). | Index view selects list without COUNT_BIG(\*) | | The indirect application of table hints to an invocation of a multi-statement table-valued function (TVF) through a view. | None. | Indirect TVF hints | | `ALTER DATABASE` syntax:

`MODIFY FILEGROUP READONLY`

`MODIFY FILEGROUP READWRITE` | `MODIFY FILEGROUP READ_ONLY`

`MODIFY FILEGROUP READ_WRITE` | `MODIFY FILEGROUP READONLY`

`MODIFY FILEGROUP READWRITE` | | `SET ANSI_NULLS OFF` and `ANSI_NULLS OFF` database option

`SET ANSI_PADDING OFF` and `ANSI_PADDING OFF` database option

`SET CONCAT_NULL_YIELDS_NULL OFF` and `CONCAT_NULL_YIELDS_NULL OFF` database option

`SET OFFSETS` | None.

`ANSI_NULLS`, `ANSI_PADDING` and CONCAT_NULLS_YIELDS_NULL are always set to `ON`. `SET OFFSETS` are unavailable. | `SET ANSI_NULLS OFF`

`SET ANSI_PADDING OFF`

`SET CONCAT_NULL_YIELDS_NULL OFF`

`SET OFFSETS`

`ALTER DATABASE SET ANSI_NULLS OFF`

`ALTER DATABASE SET ANSI_PADDING OFF`

`ALTER DATABASE SET CONCAT_NULL_YIELDS_NULL OFF` | | `SET FMTONLY` | [sys.dm_exec_describe_first_result_set](../relational-databases/system-dynamic-management-views/sys-dm-exec-describe-first-result-set-transact-sql.md), [sys.dm_exec_describe_first_result_set_for_object](../relational-databases/system-dynamic-management-views/sys-dm-exec-describe-first-result-set-for-object-transact-sql.md), [sp_describe_first_result_set](../relational-databases/system-stored-procedures/sp-describe-first-result-set-transact-sql.md), and [sp_describe_undeclared_parameters](../relational-databases/system-stored-procedures/sp-describe-undeclared-parameters-transact-sql.md). | `SET FMTONLY` | | Specifying `NOLOCK` or `READUNCOMMITTED` in the `FROM` clause of an `UPDATE` or `DELETE` statement. | Remove the `NOLOCK` or `READUNCOMMITTED` table hints from the `FROM` clause. | `NOLOCK` or `READUNCOMMITTED` in `UPDATE` or `DELETE` | | Specifying table hints without using the `WITH` keyword. | Use `WITH`. | Table hint without `WITH` | | INSERT_HINTS | | INSERT_HINTS | ### Tools | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | SQL Server Profiler for Trace Capture | Use Extended Events Profiler embedded in SQL Server Management Studio. | SQL Server Profiler | | SQL Server Profiler for Trace Replay | [SQL Server Distributed Replay overview](../tools/distributed-replay/sql-server-distributed-replay.md) | ### Trace Management Objects | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | Microsoft.SqlServer.Management.Trace namespace (contains the APIs for SQL Server Trace and Replay objects) | Trace Configuration:

Trace Reading:

Trace Replay: None | | ### XML | Deprecated feature | Replacement | Feature name | | --- | --- | --- | | Inline XDR Schema Generation | The XMLDATA directive to the `FOR XML` option is deprecated. Use XSD generation in the case of `RAW` and `AUTO` modes. There's no replacement for the XMLDATA directive in EXPLICT mode. | XMLDATA | > [!NOTE] > The cookie `OUTPUT` parameter for `sp_setapprole` is currently documented as **varbinary(8000)** which is the correct maximum length. However the current implementation returns **varbinary(50)**. If developers have allocated **varbinary(50)** the application might require changes if the cookie return size increases in a future release. Though not a deprecation issue this is mentioned in this topic because the application adjustments are similar. For more information, see [sp_setapprole](../relational-databases/system-stored-procedures/sp-setapprole-transact-sql.md). ## Related content - [Discontinued Database Engine functionality in SQL Server](discontinued-database-engine-functionality-in-sql-server.md)