SQL Server, Deprecated Features Object

SQL Server, Deprecated Features Object

 

Updated: May 3, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The SQLServer:Deprecated Features object in SQL Server provides a counter to monitor the features designated as deprecated. In each case the counter provides a usage count that lists the number of times the deprecated feature was encountered since SQL Server last started.

The value of these counters are also available by executing the following statement:

SELECT * FROM sys.dm_os_performance_counters   
WHERE object_name = 'SQLServer:Deprecated Features';  

The following table describes the SQL Server Deprecated Features counter instances.

SQL Server Deprecated Features counter instancesDescription
'#' and '##' as the name of temporary tables and stored proceduresAn identifier was encountered that did not contain any characters other than #. Use at least one additional character. Occurs once per compilation.
'::' function calling syntaxThe :: function calling syntax was encountered for a table-valued function. Replace with SELECT column_list FROM < function_name>(). For example, replace SELECT * FROM ::fn_virtualfilestats(2,1)with SELECT * FROM sys.fn_virtualfilestats(2,1). Occurs once per compilation.
'@' and names that start with '@@' as Transact-SQL identifiersAn identifier was encountered that began with @ or @@. Do not use @ or @@ or names that begin with @@ as identifiers. Occurs once per compilation.
ADDING TAPE DEVICEThe deprecated feature sp_addumpdevice'tape' was encountered. Use sp_addumpdevice'disk' instead. Occurs once per use.
ALL PermissionTotal number of times the GRANT ALL, DENY ALL, or REVOKE ALL syntax was encountered. Modify the syntax to deny specific permissions. Occurs once per query.
ALTER DATABASE WITH TORN_PAGE_DETECTIONTotal number of times the deprecated feature TORN_PAGE_DETECTION option of ALTER DATABASE has been used since the server instance was started. Use the PAGE_VERIFY syntax instead. Occurs once per use in a DDL statement.
ALTER LOGIN WITH SET CREDENTIALThe deprecated feature syntax ALTER LOGIN WITH SET CREDENTIAL or ALTER LOGIN WITH NO CREDENTIAL was encountered. Use ADD or DROP CREDENTIAL syntax instead. Occurs once per compilation.
Azeri_Cyrilllic_90Event occurs once per database start and once per collation use. Plan to modify applications that use this collation.
Azeri_Latin_90Event occurs once per database start and once per collation use. Plan to modify applications that use this collation.
BACKUP DATABASE or LOG TO TAPEThe deprecated feature BACKUP { DATABASE | LOG } TO TAPE or BACKUP { DATABASE | LOG } TO device_that_is_a_tape was encountered.

Use BACKUP { DATABASE | LOG } TO DISK or BACKUP { DATABASE | LOG } TO device_that_is_a_disk, instead. Occurs once per use.
BACKUP DATABASE or LOG WITH MEDIAPASSWORDThe deprecated feature BACKUP DATABASE WITH MEDIAPASSWORD or BACKUP LOG WITH MEDIAPASSWORD was encountered. Do not use WITH MEDIAPASSWORD.
BACKUP DATABASE or LOG WITH PASSWORDThe deprecated feature BACKUP DATABASE WITH PASSWORD or BACKUP LOG WITH PASSWORD was encountered. Do not use WITH PASSWORD.
COMPUTE [BY]The COMPUTE or COMPUTE BY syntax was encountered. Rewrite the query to use GROUP BY with ROLLUP. Occurs once per compilation.
CREATE FULLTEXT CATLOG IN PATHA CREATE FULLTEXT CATLOG statement with the IN PATH clause was encountered. This clause has no effect in this version of SQL Server. Occurs once per use.
CREATE TRIGGER WITH APPENDA CREATE TRIGGER statement with the WITH APPEND clause was encountered. Re-create the whole trigger instead. Occurs once per use in a DDL statement.
CREATE_DROP_DEFAULTThe CREATE DEFAULT or DROP DEFAULT syntax was encountered. Rewrite the command by using the DEFAULT option of CREATE TABLE or ALTER TABLE. Occurs once per compilation.
CREATE_DROP_RULEThe CREATE RULE syntax was encountered. Rewrite the command by using constraints. Occurs once per compilation.
Data types: text ntext or imageA text, ntext, or image data types was encountered. Rewrite applications to use the varchar(max) data type and removed text, ntext, and image data type syntax. Occurs once per query.
The total number of times a database was changed to compatibility level 80. Plan to upgrade the database and application before the next release. Also occurs when a database at compatibility level 80 is started.
Database compatibility level 100, 110. 120The total number of times a database compatibility level was changed. Plan to upgrade the database and application for a future release. Also occurs when a database at a deprecated compatibility level is started.
DATABASE_MIRRORINGReferences to database mirroring feature were encountered. Plan to upgrade to Always On Availability Groups, or if you are running an edition of SQL Server that does not support Always On Availability Groups, plan to migrate to log shipping.
database_principal_aliasesReferences to the deprecated sys.database_principal_aliases were encountered. Use roles instead of aliases. Occurs once per compilation.
DATABASEPROPERTYA statement referenced DATABASEPROPERTY. Update the statement DATABASEPROPERTY to DATABASEPROPERTYEX. Occurs once per compilation.
DATABASEPROPERTYEX('IsFullTextEnabled')A statement referenced the DATABASEPROPERTYEX IsFullTextEnabled property. The value of this property has no effect. User databases are always enabled for full-text search. Do not use this property. Occurs once per compilation.
DBCC [UN]PINTABLEThe DBCC PINTABLE or DBCC UNPINTABLE statement was encountered. This statement has no effect and should be removed. Occurs once per query.
DBCC DBREINDEXThe DBCC DBREINDEX statement was encountered. Rewrite the statement to use the REBUILD option of ALTER INDEX. Occurs once per query.
DBCC INDEXDEFRAGThe DBCC INDEXDEFRAG statement was encountered. Rewrite the statement to use the REORGANIZE option of ALTER INDEX. Occurs once per query.
DBCC SHOWCONTIGThe DBCC SHOWCONTIG statement was encountered. Query sys.dm_db_index_physical_stats for this information. Occurs once per query.
DEFAULT keyword as a default valueSyntax that uses the DEFAULT keyword as a default value was encountered. Do not use. Occurs once per compilation.
Deprecated encryption algorithmDeprecated encryption algorithm rc4 will be removed in the next version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. The RC4 algorithm is weak and is only supported for backward compatibility. New material can only be encrypted using RC4 or RC4_128 when the database is in compatibility level 90 or 100. (Not recommended.) Use a newer algorithm such as one of the AES algorithms instead. In SQL Server 2012 and higher material encrypted using RC4 or RC4_128 can be unencrypted in any compatibility level.
Deprecated hash algorithmUse of the MD2, MD4, MD5, SHA, or SHA1 algorithms.
DESX algorithmSyntax that uses the DESX encryption algorithm was encountered. Use another algorithm for encryption. Occurs once per compilation.
dm_fts_active_catalogsThe dm_fts_active_catalogs counter always remains at 0 because some columns of the sys.dm_fts_active_catalogs view are not deprecated. To monitor a deprecated column, use the column-specific counter; for example, dm_fts_active_catalogs.is_paused.
dm_fts_active_catalogs.is_pausedThe is_paused column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_active_catalogs.previous_statusThe previous_status column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_active_catalogs.previous_status_descriptionThe previous_status_description column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_active_catalogs.row_count_in_thousandsThe row_count_in_thousands column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_active_catalogs.statusThe status column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_active_catalogs.status_descriptionThe status_description column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_active_catalogs.worker_countThe worker_count column of the sys.dm_fts_active_catalogs dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
dm_fts_memory_buffersThe dm_fts_memory_buffers counter always remains at 0 because most columns of the sys.dm_fts_memory_buffers view are not deprecated. To monitor the deprecated column, use the column-specific counter: dm_fts_memory_buffers.row_count.
dm_fts_memory_buffers.row_countThe row_count column of the sys.dm_fts_memory_buffers dynamic management view was encountered. Avoid using this column. Occurs every time the server instance detects a reference to the column.
DROP INDEX with two-part nameThe DROP INDEX syntax contained the format table_name.index_name syntax in DROP INDEX. Replace with index_name ON table_name syntax in the DROP INDEX statement. Occurs once per compilation.
EXT_CREATE_ALTER_SOAP_ENDPOINTThe CREATE or ALTER ENDPOINT statement with the FOR SOAP option was encountered. Native XML Web Services is deprecated. Use Windows Communications Foundation (WCF) or ASP.NET instead.
EXT_endpoint_webmethodssys.endpoint_webmethods was encountered. Native XML Web Services is deprecated. Use Windows Communications Foundation (WCF) or ASP.NET instead.
EXT_soap_endpointssys.soap_endpoints was encountered. Native XML Web Services is deprecated. Use Windows Communications Foundation (WCF) or ASP.NET instead.
EXTPROP_LEVEL0TYPETYPE was encountered at a level0type. Use SCHEMA as the level0type, and TYPE as the level1type. Occurs once per query.
EXTPROP_LEVEL0USERA level0type USER when a level1type was also specified. Use USER only as a level0type for extended properties directly on a user. Occurs once per query.
FASTFIRSTROWThe FASTFIRSTROW syntax was encountered. Rewrite statements to use the OPTION (FAST n) syntax. Occurs once per compilation.
FILE_IDThe FILE_ID syntax was encountered. Rewrite statements to use FILE_IDEX. Occurs once per compilation.
fn_get_sqlThe fn_get_sql function was compiled. Use sys.dm_exec_sql_text instead. Occurs once per compilation.
fn_servershareddrivesThe fn_servershareddrives function was compiled. Use sys.dm_io_cluster_shared_drives instead. Occurs once per compilation.
fn_virtualservernodesThe fn_virtualservernodes function was compiled. Use sys.dm_os_cluster_nodes instead. Occurs once per compilation.
fulltext_catalogsThe fulltext_catalogs counter always remains at 0 because some columns of the sys.fulltext_catalogs view are not deprecated. To monitor a deprecated column, use its column-specific counter; for example, fulltext_catalogs.data_space_id. Occurs every time the server instance detects a reference to the column.
fulltext_catalogs.data_space_idThe data_space_id column of the sys.fulltext_catalogs catalog view was encountered. Do not use this column. Occurs every time the server instance detects a reference to the column.
fulltext_catalogs.file_idThe file_id column of the sys.fulltext_catalogs catalog view was encountered. Do not use this column. Occurs every time the server instance detects a reference to the column.
fulltext_catalogs.pathThe path column of the sys.fulltext_catalogs catalog view was encountered. Do not use this column. Occurs every time the server instance detects a reference to the column.
FULLTEXTCATALOGPROPERTY('LogSize')The LogSize property of the FULLTEXTCATALOGPROPERTY function was encountered. Avoid using this property.
FULLTEXTCATALOGPROPERTY('PopulateStatus')The PopulateStatus property of the FULLTEXTCATALOGPROPERTY function was encountered. Avoid using this property.
FULLTEXTSERVICEPROPERTY('ConnectTimeout')The ConnectTimeout property of the FULLTEXTSERVICEPROPERTY function was encountered. Avoid using this property.
FULLTEXTSERVICEPROPERTY('DataTimeout')The DataTimeout property of the FULLTEXTSERVICEPROPERTY function was encountered. Avoid using this property.
FULLTEXTSERVICEPROPERTY('ResourceUsage')The ResourceUsage property of the FULLTEXTSERVICEPROPERTY function was encountered. Avoid using this property.
GROUP BY ALLTotal number of times the GROUP BY ALL syntax was encountered. Modify the syntax to group by specific tables.
HindiEvent occurs once per database start and once per collation use. Plan to modify applications that use this collation. Use Indic_General_90 instead.
HOLDLOCK table hint without parentheses
IDENTITYCOLThe INDENTITYCOL syntax was encountered. Rewrite statements to use the $identity syntax. Occurs once per compilation.
Index view select list without COUNT_BIG(*)The select list of an aggregate indexed view must contain COUNT_BIG (*) .
INDEX_OPTIONEncountered CREATE TABLE, ALTER TABLE, or CREATE INDEX syntax without parentheses around the options. Rewrite the statement to use the current syntax. Occurs once per query.
INDEXKEY_PROPERTYThe INDEXKEY_PROPERTY syntax was encountered. Rewrite statements to query sys.index_columns. Occurs once per compilation.
Indirect TVF hintsThe indirect application, through a view, of table hints to an invocation of a multistatement table-valued function (TVF) will be removed in a future version of SQL Server.
INSERT NULL into TIMESTAMP columnsA NULL value was inserted to a TIMESTAMP column. Use a default value instead. Occurs once per compilation.
INSERT_HINTS
Korean_Wansung_UnicodeEvent occurs once per database start and once per collation use. Plan to modify applications that use this collation.
Lithuanian_ClassicEvent occurs once per database start and once per collation use. Plan to modify applications that use this collation.
MacedonianEvent occurs once per database start and once per collation use. Plan to modify applications that use this collation. Use Macedonian_FYROM_90 instead.
MODIFY FILEGROUP READONLYThe MODIFY FILEGROUP READONLY syntax was encountered. Rewrite statements to use the READ_ONLY syntax. Occurs once per compilation.
MODIFY FILEGROUP READWRITEThe MODIFY FILEGROUP READWRITE syntax was encountered. Rewrite statements to use the READ_WRITE syntax. Occurs once per compilation.
More than two-part column nameA query used a 3-part or 4-part name in the column list. Change the query to use the standard-compliant 2-part names. Occurs once per compilation.
Multiple table hints without commaA space was used as the separator between table hints. Use a comma instead. Occurs once per compilation.
NOLOCK or READUNCOMMITTED in UPDATE or DELETENOLOCK or READUNCOMMITTED was encountered in the FROM clause of an UPDATE or DELETE statement. Remove the NOLOCK or READUNCOMMITTED table hints from the FROM clause.
Non-ANSI *= or =* outer join operatorsA statement that uses the *= or =* join syntax was encountered. Rewrite the statement to use the ANSI join syntax. Occurs once per compilation.
numbered_stored_procedures
numbered_procedure_parametersReferences to the deprecated sys.numbered_procedure_parameters were encountered. Do not use. Occurs once per compilation.
numbered_proceduresReferences to the deprecated sys.numbered_procedures were encountered. Do not use. Occurs once per compilation.
Oldstyle RAISEERRORThe deprecated RAISERROR (Format: RAISERROR integer string) syntax was encountered. Rewrite the statement using the current RAISERROR syntax. Occurs once per compilation.
OLEDB for ad hoc connectionsSQLOLEDB is not a supported provider. Use SQL Server Native Client for ad hoc connections.
PERMISSIONSReferences to the PERMISSIONS intrinsic function were encountered. Query sys.fn_my_permissions instead. Occurs once per query.
ProcNumsThe deprecated ProcNums syntax was encountered. Rewrite statements to remove the references. Occurs once per compilation.
READTEXTThe READTEXT syntax was encountered. Rewrite applications to use the varchar(max) data type and removed text data type syntax. Occurs once per query.
RESTORE DATABASE or LOG WITH DBO_ONLYThe RESTORE … WITH DBO_ONLY syntax was encountered. Use RESTORE … RESTRICTED_USER instead.
RESTORE DATABASE or LOG WITH MEDIAPASSWORDThe RESTORE … WITH MEDIAPASSWORD syntax was encountered. WITH MEDIAPASSWORD provides weak security and should be removed.
RESTORE DATABASE or LOG WITH PASSWORDThe RESTORE … WITH PASSWORD syntax was encountered. WITH PASSWORD provides weak security and should be removed.
Returning results from triggerThis event occurs once per trigger invocation. Rewrite the trigger so that it does not return result sets.
ROWGUIDCOLThe ROWGUIDCOL syntax was encountered. Rewrite statements to use the $rowguid syntax. Occurs once per compilation.
SET ANSI_NULLS OFFThe SET ANSI_NULLS OFF syntax was encountered. Remove this deprecated syntax. Occurs once per compilation.
SET ANSI_PADDING OFFThe SET ANSI_PADDING OFF syntax was encountered. Remove this deprecated syntax. Occurs once per compilation.
SET CONCAT_NULL_YIELDS_NULL OFFThe SET CONCAT_NULL_YIELDS_NULL OFF syntax was encountered. Remove this deprecated syntax. Occurs once per compilation.
SET DISABLE_DEF_CNST_CHKThe SET DISABLE_DEF_CNST_CHK syntax was encountered. This has no effect. Remove this deprecated syntax. Occurs once per compilation.
SET FMTONLY ONThe SET FMTONLY syntax was encountered. Remove this deprecated syntax. Occurs once per compilation.
SET OFFSETSThe SET OFFSETS syntax was encountered. Remove this deprecated syntax. Occurs once per compilation.
SET REMOTE_PROC_TRANSACTIONSThe SET REMOTE_PROC_TRANSACTIONS syntax was encountered. Remove this deprecated syntax. Use linked servers and sp_serveroption instead.
SET ROWCOUNTThe SET ROWCOUNT syntax was encountered in a DELETE, INSERT, or UPDATE statement. Rewrite the statement by using TOP. Occurs once per compilation.
SETUSERThe SET USER statement was encountered. Use EXECUTE AS instead. Occurs once per query.
sp_addapproleThe sp_addapprole procedure was encountered. Use CREATE APPLICATION ROLE instead. Occurs once per query.
sp_addextendedprocThe sp_addextendedproc procedure was encountered. Use CLR instead. Occurs once per compilation.
sp_addloginThe sp_addlogin procedure was encountered. Use CREATE LOGIN instead. Occurs once per query.
sp_addremoteloginThe sp_addremotelogin procedure was encountered. Use linked servers instead.
sp_addroleThe sp_addrole procedure was encountered. Use CREATE ROLE instead. Occurs once per query.
sp_addserverThe sp_addserver procedure was encountered. Use linked servers instead.
sp_addtypeThe sp_addtype procedure was encountered. Use CREATE TYPE instead. Occurs once per compilation.
sp_adduserThe sp_adduser procedure was encountered. Use CREATE USER instead. Occurs once per query.
sp_approlepasswordThe sp_approlepassword procedure was encountered. Use ALTER APPLICATION ROLE instead. Occurs once per query.
sp_attach_dbThe sp_attach_db procedure was encountered. Use CREATE DATABASE FOR ATTACH instead. Occurs once per query.
sp_attach_single_file_dbThe sp_single_file_db procedure was encountered. Use CREATE DATABASE FOR ATTACH_REBUILD_LOG instead. Occurs once per query.
sp_bindefaultThe sp_bindefault procedure was encountered. Use the DEFAULT keyword of ALTER TABLE or CREATE TABLE instead. Occurs once per compilation.
sp_bindruleThe sp_bindrule procedure was encountered. Use check constraints instead. Occurs once per compilation.
sp_bindsessionThe sp_bindsession procedure was encountered. Use Multiple Active Result Sets (MARS) or distributed transactions instead. Occurs once per compilation.
sp_certify_removableThe sp_certify_removable procedure was encountered. Use sp_detach_db instead. Occurs once per query.
sp_changeobjectownerThe sp_changeobjectowner procedure was encountered. Use ALTER SCHEMA or ALTER AUTHORIZATION instead. Occurs once per query.
sp_change_users_loginThe sp_change_users_login procedure was encountered. Use ALTER USER instead. Occurs once per query.
sp_configure 'allow updates'The allow updates option of sp_configure was encountered. System tables are no longer updatable. Do not use. Occurs once per query.
sp_configure 'disallow results from triggers'The disallow result sets from triggers option of sp_configure was encountered. To disallow result sets from triggers, use sp_configure to set the option to 1. Occurs once per query.
sp_configure 'ft crawl bandwidth (max)'The ft crawl bandwidth (max) option of sp_configure was encountered. Do not use. Occurs once per query.
sp_configure 'ft crawl bandwidth (min)'The ft crawl bandwidth (min) option of sp_configure was encountered. Do not use. Occurs once per query.
sp_configure 'ft notify bandwidth (max)'The ft notify bandwidth (max) option of sp_configure was encountered. Do not use. Occurs once per query.
sp_configure 'ft notify bandwidth (min)'The ft notify bandwidth (min) option of sp_configure was encountered. Do not use. Occurs once per query.
sp_configure 'locks'The locks option of sp_configure was encountered. Locks are no longer configurable. Do not use. Occurs once per query.
sp_configure 'open objects'The open objects option of sp_configure was encountered. The number of open objects is no longer configurable. Do not use. Occurs once per query.
sp_configure 'priority boost'The priority boost option of sp_configure was encountered. Do not use. Occurs once per query. Use the Windows start /high … program.exe option instead.
sp_configure 'remote proc trans'The remote proc trans option of sp_configure was encountered. Do not use. Occurs once per query.
sp_configure 'set working set size'The set working set size option of sp_configure was encountered. The working set size is no longer configurable. Do not use. Occurs once per query.
sp_control_dbmasterkey_passwordThe sp_control_dbmasterkey_password stored procedure does not check whether a master key exists. This is permitted for backward compatibility, but displays a warning. This behavior is deprecated. In a future release the master key must exist and the password used in the stored procedure sp_control_dbmasterkey_password must be the same password as one of the passwords used to encrypt the database master key.
sp_create_removableThe sp_create_removable procedure was encountered. Use CREATE DATABASE instead. Occurs once per query.
sp_db_vardecimal_storage_formatUse of vardecimal storage format was encountered. Use data compression instead.
sp_dbcmptlevelThe sp_dbcmptlevel procedure was encountered. Use ALTER DATABASE … SET COMPATIBILITY_LEVEL instead. Occurs once per query.
sp_dbfixedrolepermissionThe sp_dbfixedrolepermission procedure was encountered. Do not use. Occurs once per query.
sp_dboptionThe sp_dboption procedure was encountered. Use ALTER DATABASE and DATABASEPROPERTYEX instead. Occurs once per compilation.
sp_dbremoveThe sp_dbremove procedure was encountered. Use DROP DATABASE instead. Occurs once per query.
sp_defaultdbThe sp_defaultdb procedure was encountered. Use ALTER LOGIN instead. Occurs once per compilation.
sp_defaultlanguageThe sp_defaultlanguage procedure was encountered. Use ALTER LOGIN instead. Occurs once per compilation.
sp_denyloginThe sp_denylogin procedure was encountered. Use ALTER LOGIN DISABLE instead. Occurs once per query.
sp_dependsThe sp_depends procedure was encountered. Use sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities instead. Occurs once per query.
sp_detach_db @keepfulltextindexfileThe @keepfulltextindexfile argument was encountered in a sp_detach_db statement. Do not use this argument.
sp_dropaliasThe sp_dropalias procedure was encountered. Replace aliases with a combination of user accounts and database roles. Use sp_dropalias to remove aliases in upgraded databases. Occurs once per compilation.
sp_dropapproleThe sp_dropapprole procedure was encountered. Use DROP APPLICATION ROLE instead. Occurs once per query.
sp_dropextendedprocThe sp_dropextendedproc procedure was encountered. Use CLR instead. Occurs once per compilation.
sp_droploginThe sp_droplogin procedure was encountered. Use DROP LOGIN instead. Occurs once per query.
sp_dropremoteloginThe sp_dropremotelogin procedure was encountered. Use linked servers instead.
sp_droproleThe sp_droprole procedure was encountered. Use DROP ROLE instead. Occurs once per query.
sp_droptypeThe sp_droptype procedure was encountered. Use DROP TYPE instead.
sp_dropuserThe sp_dropuser procedure was encountered. Use DROP USER instead. Occurs once per query.
sp_estimated_rowsize_reduction_for_vardecimalUse of vardecimal storage format was encountered. Use data compression and sp_estimate_data_compression_savings instead.
sp_fulltext_catalogThe sp_fulltext_catalog procedure was encountered. Use CREATE/ALTER/DROP FULLTEXT CATALOG instead. Occurs once per compilation.
sp_fulltext_columnThe sp_fulltext_column procedure was encountered. Use ALTER FULLTEXT INDEX instead. Occurs once per compilation.
sp_fulltext_databaseThe sp_fulltext_database procedure was encountered. Use ALTER DATABASE instead. Occurs once per compilation.
sp_fulltext_service @action=clean_upThe clean_up option of the sp_fulltext_service procedure was encountered. Occurs once per query.
sp_fulltext_service @action=connect_timeoutThe connect_timeout option of the sp_fulltext_service procedure was encountered. Occurs once per query.
sp_fulltext_service @action=data_timeoutThe data_timeout option of the sp_fulltext_service procedure was encountered. Occurs once per query.
sp_fulltext_service @action=resource_usageThe resource_usage option of the sp_fulltext_service procedure was encountered. This option has no function. Occurs once per query.
sp_fulltext_tableThe sp_fulltext_table procedure was encountered. Use CREATE/ALTER/DROP FULLTEXT INDEX instead. Occurs once per compilation.
sp_getbindtokenThe sp_getbindtoken procedure was encountered. Use Multiple Active Result Sets (MARS) or distributed transactions instead. Occurs once per compilation.
sp_grantdbaccessThe sp_grantdbaccess procedure was encountered. Use CREATE USER instead. Occurs once per query.
sp_grantloginThe sp_grantlogin procedure was encountered. Use CREATE LOGIN instead. Occurs once per query.
sp_help_fulltext_catalog_componentsThe sp_help_fulltext_catalog_components procedure was encountered. This procedure returns empty rows. Do not use this procedure. Occurs once per compilation.
sp_help_fulltext_catalogsThe sp_help_fulltext_catalogs procedure was encountered. Query sys.fulltext_catalogs instead. Occurs once per compilation.
sp_help_fulltext_catalogs_cursorThe sp_help_fulltext_catalogs_cursor procedure was encountered. Query sys.fulltext_catalogs instead. Occurs once per compilation.
sp_help_fulltext_columnsThe sp_help_fulltext_columns procedure was encountered. Query sys.fulltext_index_columns instead. Occurs once per compilation.
sp_help_fulltext_columns_cursorThe sp_help_fulltext_columns_cursor procedure was encountered. Query sys.fulltext_index_columns instead. Occurs once per compilation.
sp_help_fulltext_tablesThe sp_help_fulltext_tables procedure was encountered. Query sys.fulltext_indexes instead. Occurs once per compilation.
sp_help_fulltext_tables_cursorThe sp_help_fulltext_tables_cursor procedure was encountered. Query sys.fulltext_indexes instead. Occurs once per compilation.
sp_helpdeviceThe sp_helpdevice procedure was encountered. Query sys.backup_devices instead. Occurs once per query.
sp_helpextendedprocThe sp_helpextendedproc procedure was encountered. Use CLR instead. Occurs once per compilation.
sp_helpremoteloginThe sp_helpremotelogin procedure was encountered. Use linked servers instead.
sp_indexoptionThe sp_indexoption procedure was encountered. Use ALTER INDEX instead. Occurs once per compilation.
sp_lockThe sp_lock procedure was encountered. Query sys.dm_tran_locks instead. Occurs once per query.
sp_passwordThe sp_password procedure was encountered. Use ALTER LOGIN instead. Occurs once per query.
sp_remoteoptionThe sp_remoteoption procedure was encountered. Use linked servers instead.
sp_renamedbThe sp_renamedb procedure was encountered. Use ALTER DATABASE instead. Occurs once per query.
sp_resetstatusThe sp_resetstatus procedure was encountered. Use ALTER DATABASE instead. Occurs once per query.
sp_revokedbaccessThe sp_revokedbaccess procedure was encountered. Use DROP USER instead. Occurs once per query.
sp_revokeloginThe sp_revokelogin procedure was encountered. Use DROP LOGIN instead. Occurs once per query.
sp_srvrolepermissionThe deprecated sp_srvrolepermission procedure was encountered. Do not use. Occurs once per query.
sp_unbindefaultThe sp_unbindefault procedure was encountered. Use the DEFAULT keyword in CREATE TABLE or ALTER TABLE statements instead. Occurs once per compilation.
sp_unbindruleThe sp_unbindrule procedure was encountered. Use check constraints instead of rules. Occurs once per compilation.
SQL_AltDiction_CP1253_CS_ASEvent occurs once per database start and once per collation use. Plan to modify applications that use this collation.
String literals as column aliasesSyntax that contains a string that is used as a column alias in a SELECT statement, such as 'string' = expression, was encountered. Do not use. Occurs once per compilation.
sys.sql_dependenciesReferences to sys.sql_dependencies were encountered. Use sys.sql_expression_dependencies instead. Occurs once per compilation.
sysaltfilesReferences to sysaltfiles were encountered. Use sys.master_files instead. Occurs once per compilation.
syscacheobjectsReferences to syscacheobjects were encountered. Use sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, and sys.dm_exec_sql_text instead. Occurs once per compilation.
syscolumnsReferences to syscolumns were encountered. Use sys.columns instead. Occurs once per compilation.
syscommentsReferences to syscomments were encountered. Use sys.sql_modules instead. Occurs once per compilation.
sysconfiguresReferences to the sysconfigures table were encountered. Reference the sys.sysconfigures view instead. Occurs once per compilation.
sysconstraintsReferences to sysconstraints were encountered Use sys.check_constraints, sys.default_constraints, sys.key_constraints, sys.foreign_keys instead. Occurs once per compilation.
syscurconfigsReferences to syscurconfigs were encountered. Use sys.configurations instead. Occurs once per compilation.
sysdatabasesReferences to sysdatabases were encountered. Use sys.databases instead. Occurs once per compilation.
sysdependsReferences to sysdepends were encountered. Use sys.sql_dependencies instead. Occurs once per compilation.
sysdevicesReferences to sysdevices were encountered. Use sys.backup_devices instead. Occurs once per compilation.
sysfilegroupsReferences to sysfilegroups were encountered. Use sys.filegroups instead. Occurs once per compilation.
sysfilesReferences to sysfiles were encountered. Use sys.database_files instead. Occurs once per compilation.
sysforeignkeysReferences to sysforeignkeys were encountered. Use sys.foreign_keys instead. Occurs once per compilation.
sysfulltextcatalogsReferences to sysfulltextcatalogs were encountered. Use sys.fulltext_catalogs instead. Occurs once per compilation.
sysindexesReferences to sysindexes were encountered. Use sys.indexes, sys.partitions, sys.allocation_units, and sys.dm_db_partition_stats instead. Occurs once per compilation.
sysindexkeysReferences to sysindexkeys were encountered. Use sys.index_columns instead. Occurs once per compilation.
syslockinfoReferences to syslockinfo were encountered. Use sys.dm_tran_locks instead. Occurs once per compilation.
sysloginsReferences to syslogins were encountered. Use sys.server_principals and sys.sql_logins instead. Occurs once per compilation.
sysmembersReferences to sysmembers were encountered. Use sys.database_role_members instead. Occurs once per compilation.
sysmessagesReferences to sysmessages were encountered. Use sys.messages instead. Occurs once per compilation.
sysobjectsReferences to sysobjects were encountered. Use sys.objects instead. Occurs once per compilation.
sysoledbusersReferences to sysoledbusers were encountered. Use sys.linked_logins instead. Occurs once per compilation.
sysopentapesReferences to sysopentapes were encountered. Use sys.dm_io_backup_tapes instead. Occurs once per compilation.
sysperfinfoReferences to sysperfinfo were encountered. Use sys.dm_os_performance_counters. instead. Occurs once per compilation.
syspermissionsReferences to syspermissions were encountered. Use sys.database_permissions and sys.server_permissions instead. Occurs once per compilation.
sysprocessesReferences to sysprocesses were encountered. Use sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests instead. Occurs once per compilation.
sysprotectsReferences to sysprotects were encountered. Use sys.database_permissions and sys.server_permissions instead. Occurs once per compilation.
sysreferencesReferences to sysreferences were encountered. Use sys.foreign_keys instead. Occurs once per compilation.
sysremoteloginsReferences to sysremotelogins were encountered. Use sys.remote_logins instead. Occurs once per compilation.
sysserversReferences to sysservers were encountered. Use sys.servers instead. Occurs once per compilation.
systypesReferences to systypes were encountered. Use sys.types instead. Occurs once per compilation.
sysusersReferences to sysusers were encountered. Use sys.database_principals instead. Occurs once per compilation.
Table hint without WITHA statement that used table hints but did not use the WITH keyword was encountered. Modify statements to include the word WITH. Occurs once per compilation.
Text in row table optionReferences to the 'text in row' table option were encountered. Use sp_tableoption 'large value types out of row' instead. Occurs once per query.
TEXTPTRReferences to the TEXTPTR function were encountered. Rewrite applications to use the varchar(max) data type and removed text, ntext, and image data type syntax. Occurs once per query.
TEXTVALIDReferences to the TEXTVALID function were encountered. Rewrite applications to use the varchar(max) data type and removed text, ntext, and image data type syntax. Occurs once per query.
TIMESTAMPTotal number of times the deprecated timestamp data type was encountered in a DDL statement. Use the rowversion data type instead.
UPDATETEXT or WRITETEXTThe UPDATETEXT or WRITETEXT statement was encountered. Rewrite applications to use the varchar(max) data type and removed text, ntext, and image data type syntax. Occurs once per query.
USER_IDReferences to the USER_ID function were encountered. Use the DATABASE_PRINCIPAL_ID function instead. Occurs once per compilation.
Using OLEDB for linked servers
Vardecimal storage formatUse of vardecimal storage format was encountered. Use data compression instead.
XMLDATAThe FOR XML syntax was encountered. Use XSD generation for RAW and AUTO modes. There is no replacement for the explicit mode. Occurs once per compilation.
XP_APIAn extended stored procedure statement was encountered. Do not use.
xp_grantloginThe xp_grantlogin procedure was encountered. Use CREATE LOGIN instead. Occurs once per compilation.
xp_loginconfigThe xp_loginconfig procedure was encountered. Use the IsIntegratedSecurityOnly argument of SERVERPROPERTY instead. Occurs once per query.
xp_revokeloginThe xp_revokelogin procedure was encountered. Use ALTER LOGIN DISABLE or DROP LOGIN instead. Occurs once per compilation.

Deprecated Database Engine Features in SQL Server 2016
Deprecated Full-Text Search Features in SQL Server 2016
Deprecation Announcement Event Class
Deprecation Final Support Event Class
Discontinued Database Engine Functionality in SQL Server 2016
Discontinued Full-Text Search Features in SQL Server 2016
Use SQL Server Objects

Community Additions

ADD
Show:
© 2016 Microsoft