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 S e rver 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:
|
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:
|
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.
Reference
Deprecated Database Engine Features in SQL Server 2008
Concepts
Breaking Changes to Full-Text Search in SQL Server 2008
Other Resources
SQL Server, Deprecated Features Object
Help and Information
Getting SQL Server 2008 Assistance