Deprecated Full-Text Search Features in SQL Server 2012

  • Article

This topic describes the deprecated full-text search features that are still available in SQL Server 2012. 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

Reference

SQL Server, Deprecated Features Object

Deprecated Database Engine Features in SQL Server 2012

Concepts

Breaking Changes to Full-Text Search