title: "Deprecated Full-Text Search Features in SQL Server 2016 | Microsoft Docs" ms.custom: "" ms.date: "08/19/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "search" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "article" helpviewer_keywords:
- "deprecated features [full-text search]"
- "full-text search [SQL Server], deprecated features"
- "full-text queries [SQL Server], proximity" ms.assetid: ab0d799c-ba79-4459-837b-c4862730dafd caps.latest.revision: 33 author: "douglaslMS" ms.author: "douglasl" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] 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.
| 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=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/da4e79829135b33a03743e1edd77fc9c738f2fbb/docs/relational-databases/search/clean_up%3Cbr> sp_fulltext_service @action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/da4e79829135b33a03743e1edd77fc9c738f2fbb/docs/relational-databases/search/connect_timeout%3Cbr> sp_fulltext_service @action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/da4e79829135b33a03743e1edd77fc9c738f2fbb/docs/relational-databases/search/data_timeout%3C/td> | 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 |
The following full-text search features are supported in the next version of [!INCLUDEssNoVersion], but will be removed in a later version. The specific version of [!INCLUDEssNoVersion] 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] ) [, [,] ] } ) ::= {integer | MAX} ::= {TRUE | FALSE} |
FULLTEXT_OLD_NEAR_SYNTAX | 247 |
| CREATE FULLTEXT CATALOG option: IN PATH 'rootpath' ON FILEGROUP filegroup |
None. | CREATE FULLTEXT CATLOG 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=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/da4e79829135b33a03743e1edd77fc9c738f2fbb/docs/relational-databases/search/resource_usage%3C/td> | 200 |
*The SQL Server:Deprecated Features object does not monitor occurrences of CREATE FULLTEXT CATLOG ON FILEGROUP filegroup.