Skip to content

deprecated-full-text-search-features-in-sql-server-2016.md

Latest commit

 

History

History
56 lines (46 loc) · 6.18 KB

deprecated-full-text-search-features-in-sql-server-2016.md

File metadata and controls

56 lines (46 loc) · 6.18 KB
title Deprecated Full-Text Search features in SQL Server 2016
ms.custom seo-lt-2019
ms.date 08/19/2016
ms.prod sql
ms.prod_service search, sql-database
ms.technology search
ms.topic conceptual
helpviewer_keywords
deprecated features [full-text search]
full-text search [SQL Server], deprecated features
full-text queries [SQL Server], proximity
ms.assetid ab0d799c-ba79-4459-837b-c4862730dafd
author pmasl
ms.author pelopes
ms.reviewer mikeray
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Deprecated Full-Text Search features in SQL Server 2016

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] This topic describes the deprecated full-text search features still available in SQL Server. These features are scheduled to be removed in a future release. Do not use deprecated features in new applications.

Monitor your 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 no longer supported

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=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/relational-databases/search/clean_up%3Cbr>
sp_fulltext_service @action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/relational-databases/search/connect_timeout%3Cbr>
sp_fulltext_service @action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/relational-databases/search/data_timeout%3C/td> 		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 [!INCLUDEssNoVersion], but will be removed in a later version. The specific version of [!INCLUDEssNoVersion] 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] )

[, [,] ]

}

)

::= {integer | MAX}

::= {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=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/relational-databases/search/resource_usage%3C/td> 200

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