Deprecated Full-Text Search features in SQL Server 2016

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

This topic describes the deprecated full-text search features still available in SQL Server. These features are scheduled to be removed in a future release. Do not use deprecated features in new applications.

Monitor your use of deprecated features by using the SQL Server:Deprecated Features object performance counter and trace events. For more information, see Use SQL Server Objects.

Features no longer supported

Deprecated feature	Replacement	Feature name	Feature ID
FULLTEXTCATALOGPROPERTY property: LogSize	None.	FULLTEXTCATALOGPROPERTY**('LogSize')**	211
FULLTEXTSERVICEPROPERTY property: ConnectTimeout DataTimeout	None.	FULLTEXTSERVICEPROPERTY**('ConnectTimeout') FULLTEXTSERVICEPROPERTY('DataTimeout'**)	210 209
sp_fulltext_catalog	CREATE FULL CATALOG ALTER FULLTEXT CATALOG DROP FULLTEXT CATALOG	sp_fulltext_catalog	84
sp_fulltext_column sp_fulltext_database sp_fulltext_table	CREATE FULL INDEX ALTER FULLTEXT INDEX DROP FULLTEXT INDEX	sp_fulltext_column sp_fulltext_database sp_fulltext_table	86 87 85
sp_help_fulltext_catalogs sp_help_fulltext_catalog_components sp_help_fulltext_catalogs_cursor sp_help_fulltext_columns sp_help_fulltext_columns_cursor sp_help_fulltext_tables sp_help_fulltext_tables_cursor	sys.fulltext_catalogs sys.fulltext_index_columns sys.fulltext_indexes	sp_help_fulltext_catalogs sp_help_fulltext_catalog_components sp_help_fulltext_catalogs_cursor sp_help_fulltext_columns sp_help_fulltext_columns_cursor sp_help_fulltext_table sp_help_fulltext_tables_cursor	88 203 90 92 93 91 89
sp_fulltext_service action values: clean_up, connect_timeout, and data_timeout return zero	None	sp_fulltext_service @action=clean_up sp_fulltext_service @action=connect_timeout sp_fulltext_service @action=data_timeout	116 117 118
sys.dm_fts_active_catalogs columns: is_paused previous_status previous_status_description row_count_in_thousands status status_description worker_count	None.	dm_fts_active_catalogs.is_paused dm_fts_active_catalogs.previous_status dm_fts_active_catalogs.previous_status_description dm_fts_active_catalogs.row_count_in_thousands dm_fts_active_catalogs.status dm_fts_active_catalogs.status_description dm_fts_active_catalogs.worker_count	218 221 222 224 219 220 223
sys.dm_fts_memory_buffers column: row_count	None.	dm_fts_memory_buffers.row_count	225
sys.fulltext_catalogs columns: path data_space_id file_id columns	None.	fulltext_catalogs.path fulltext_catalogs.data_space_id fulltext_catalogs.file_id	215 216 217

Features Not Supported in a Future Version of SQL Server

The following full-text search features are supported in the next version of SQL Server, but will be removed in a later version. The specific version of SQL Server has not been determined.

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.

Deprecated feature	Replacement	Feature name	Feature ID
CONTAINS and CONTAINSTABLE generic NEAR operator: {<simple_term> | <prefix_term>} { { { NEAR | ~ } {<simple_term> | <prefix_term>} } [...n] }	The custom NEAR operator: NEAR( { {<simple_term> | <prefix_term>} [ ,...n ] | ( {<simple_term> | <prefix_term>} [,...n] ) [,<distance> [,<order>] ] } ) <distance> ::= {integer | MAX} <order> ::= {TRUE | FALSE}	FULLTEXT_OLD_NEAR_SYNTAX	247
CREATE FULLTEXT CATALOG option: IN PATH 'rootpath' ON FILEGROUP filegroup	None.	CREATE FULLTEXT CATALOG IN PATH None.*	237 None.*
DATABASEPROPERTYEX property: IsFullTextEnabled	None.	DATABASEPROPERTYEX**('IsFullTextEnabled')**	202
sp_detach_db option: [ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'	None.	sp_detach_db @keepfulltextindexfile	226
sp_fulltext_service action values: resource_usage has no function.	None	sp_fulltext_service @action=resource_usage	200

*The SQL Server:Deprecated Features object does not monitor occurrences of CREATE FULLTEXT CATALOG ON FILEGROUP filegroup.