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 |
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] ) [, } ) | 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 |