Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This topic describes the deprecated full-text search features that are still available in SQL Server 2014. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.
You can monitor the 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 Not Supported in the Next Version of SQL Server
The following full-text search features will not be supported in the next release of SQL Server.
| 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 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=resource_usage | 200 |
*The SQL Server:Deprecated Features object does not monitor occurrences of CREATE FULLTEXT CATLOG ON FILEGROUP filegroup.
See Also
SQL Server, Deprecated Features Object
Breaking Changes to Full-Text Search
Deprecated Database Engine Features in SQL Server 2014