• Article

Deprecated Full-Text Search Features in SQL Server 2008 R2

Note

For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

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

Features Not Supported in the Next Version of SQL Server

No full-text search features will be discontinued in the next release of SQL Server.

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

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

FULLTEXTCATALOGPROPERTY property:

  • LogSize

  • PopulateStatus

None.

FULLTEXTCATALOGPROPERTY('LogSize')

FULLTEXTCATALOGPROPERTY('PopulateStatus')

211

201

FULLTEXTSERVICEPROPERTY property:

  • ConnectTimeout

  • DataTimeout

  • ResourceUsage

None.

FULLTEXTSERVICEPROPERTY('ConnectTimeout')

FULLTEXTSERVICEPROPERTY('DataTimeout')

FULLTEXTSERVICEPROPERTY('ResourceUsage')

210

209

208

sp_configure options:

  • ft crawl bandwidth

  • ft notify bandwidth

None.

sp_configure 'ft crawl bandwidth (max)'

sp_configure 'ft crawl bandwidth (min)'

sp_configure 'ft notify bandwidth (max)'

sp_configure 'ft notify bandwidth (min)'

204

205

206

207

sp_detach_db option:

[ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'

None.

sp_detach_db @keepfulltextindexfile

226

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

  • resource_usage has no function.

None

  • sp_fulltext_service @action=clean_up

  • sp_fulltext_service @action=connect_timeout

  • sp_fulltext_service @action=data_timeout

  • sp_fulltext_service @action=resource_usage

116

117

118

200

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 SQL Server:Deprecated Features object does not monitor occurrences of CREATE FULLTEXT CATLOG ON FILEGROUP filegroup.