Deprecated Full-Text Search Features in SQL Server 2016

 

Updated: August 19, 2016

Applies To: SQL Server 2016

This topic describes the deprecated full-text search features still available in SQL Server 2016. These features are scheduled to be removed in a future release of SQL Server. Do not use deprecated features 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.

Deprecated featureReplacementFeature nameFeature ID
FULLTEXTCATALOGPROPERTY property: LogSizeNone.FULLTEXTCATALOGPROPERTY('LogSize')211
FULLTEXTSERVICEPROPERTY property:

ConnectTimeout

DataTimeout
None.FULLTEXTSERVICEPROPERTY('ConnectTimeout')

FULLTEXTSERVICEPROPERTY('DataTimeout')
210

209
sp_fulltext_catalogCREATE FULL CATALOG

ALTER FULLTEXT CATALOG

DROP FULLTEXT CATALOG
sp_fulltext_catalog84
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 zeroNonesp_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_count225
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 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 featureReplacementFeature nameFeature 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_SYNTAX247
CREATE FULLTEXT CATALOG option:

IN PATH 'rootpath'

ON FILEGROUP filegroup
None.CREATE FULLTEXT CATLOG IN PATH

None.*
237

None.*
DATABASEPROPERTYEX property: IsFullTextEnabledNone.DATABASEPROPERTYEX('IsFullTextEnabled')202
sp_detach_db option:

[ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'
None.sp_detach_db @keepfulltextindexfile226
sp_fulltext_service action values: resource_usage has no function.Nonesp_fulltext_service @action=resource_usage200

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

Community Additions

ADD
Show: