Export (0) Print
Expand All

Deprecated Full-Text Search Features in SQL Server 2014

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.

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft