Funzionalità deprecate della ricerca full-text in SQL Server 2016Deprecated Full-Text Search Features in SQL Server 2016

Questo argomento descrive le funzionalità deprecate della ricerca full-text ancora disponibili in SQL Server.This topic describes the deprecated full-text search features still available in SQL Server. Tali funzionalità verranno rimosse a partire da una delle prossime versioni.These features are scheduled to be removed in a future release. Non usare funzionalità deprecate nelle nuove applicazioni.Do not use deprecated features in new applications.

È possibile monitorare l'uso delle funzionalità deprecate usando il contatore delle prestazioni dell'oggetto SQL Server:Deprecated Features e gli eventi di traccia.Monitor your use of deprecated features by using the SQL Server:Deprecated Features object performance counter and trace events. Per altre informazioni, vedere Usare oggetti di SQL Server.For more information, see Use SQL Server Objects.

Funzionalità non più supportateFeatures no longer supported

Funzionalità deprecataDeprecated feature SostituzioneReplacement Nome funzionalitàFeature name ID funzionalitàFeature ID
Proprietà FULLTEXTCATALOGPROPERTY: LogSizeFULLTEXTCATALOGPROPERTY property: LogSize nessuna.None. FULLTEXTCATALOGPROPERTY('LogSize')FULLTEXTCATALOGPROPERTY('LogSize') 211211
Proprietà di FULLTEXTSERVICEPROPERTY:FULLTEXTSERVICEPROPERTY property:

ConnectTimeoutConnectTimeout

DataTimeoutDataTimeout
nessuna.None. FULLTEXTSERVICEPROPERTY('ConnectTimeout')FULLTEXTSERVICEPROPERTY('ConnectTimeout')

FULLTEXTSERVICEPROPERTY('DataTimeout')FULLTEXTSERVICEPROPERTY('DataTimeout')
210210

209209
sp_fulltext_catalogsp_fulltext_catalog CREATE FULL CATALOGCREATE FULL CATALOG

ALTER FULLTEXT CATALOGALTER FULLTEXT CATALOG

DROP FULLTEXT CATALOGDROP FULLTEXT CATALOG
sp_fulltext_catalogsp_fulltext_catalog 8484
sp_fulltext_columnsp_fulltext_column

sp_fulltext_databasesp_fulltext_database

sp_fulltext_tablesp_fulltext_table
CREATE FULL INDEXCREATE FULL INDEX

ALTER FULLTEXT INDEXALTER FULLTEXT INDEX

DROP FULLTEXT INDEXDROP FULLTEXT INDEX
sp_fulltext_columnsp_fulltext_column

sp_fulltext_databasesp_fulltext_database

sp_fulltext_tablesp_fulltext_table
8686

8787

8585
sp_help_fulltext_catalogssp_help_fulltext_catalogs

sp_help_fulltext_catalog_componentssp_help_fulltext_catalog_components

sp_help_fulltext_catalogs_cursorsp_help_fulltext_catalogs_cursor

sp_help_fulltext_columnssp_help_fulltext_columns

sp_help_fulltext_columns_cursorsp_help_fulltext_columns_cursor

sp_help_fulltext_tablessp_help_fulltext_tables

sp_help_fulltext_tables_cursorsp_help_fulltext_tables_cursor
sys.fulltext_catalogssys.fulltext_catalogs

sys.fulltext_index_columnssys.fulltext_index_columns

sys.fulltext_indexessys.fulltext_indexes
sp_help_fulltext_catalogssp_help_fulltext_catalogs

sp_help_fulltext_catalog_componentssp_help_fulltext_catalog_components

sp_help_fulltext_catalogs_cursorsp_help_fulltext_catalogs_cursor

sp_help_fulltext_columnssp_help_fulltext_columns

sp_help_fulltext_columns_cursorsp_help_fulltext_columns_cursor

sp_help_fulltext_tablesp_help_fulltext_table

sp_help_fulltext_tables_cursorsp_help_fulltext_tables_cursor
8888

203203

9090

9292

9393

9191

8989
sp_fulltext_service action values: clean_up, connect_timeout e data_timeout return zerosp_fulltext_service action values: clean_up, connect_timeout, and data_timeout return zero NessunoNone sp_fulltext_service @action=clean_up</span><span class="sxs-lookup">sp_fulltext_service @action=clean_up</span></span><br />
sp_fulltext_service @action=connect_timeout</span><span class="sxs-lookup">sp_fulltext_service @action=connect_timeout</span></span><br />
sp_fulltext_service @action=data_timeout</span><span class="sxs-lookup">sp_fulltext_service @action=data_timeout</span></span>
116116

117117

118118
Colonne sys.dm_fts_active_catalogs:sys.dm_fts_active_catalogs columns:

is_pausedis_paused

previous_statusprevious_status

previous_status_descriptionprevious_status_description

row_count_in_thousandsrow_count_in_thousands

statusstatus

status_descriptionstatus_description

worker_countworker_count
nessuna.None. dm_fts_active_catalogs.is_pauseddm_fts_active_catalogs.is_paused

dm_fts_active_catalogs.previous_statusdm_fts_active_catalogs.previous_status

dm_fts_active_catalogs.previous_status_descriptiondm_fts_active_catalogs.previous_status_description

dm_fts_active_catalogs.row_count_in_thousandsdm_fts_active_catalogs.row_count_in_thousands

dm_fts_active_catalogs.statusdm_fts_active_catalogs.status

dm_fts_active_catalogs.status_descriptiondm_fts_active_catalogs.status_description

dm_fts_active_catalogs.worker_countdm_fts_active_catalogs.worker_count
218218

221221

222222

224224

219219

220220

223223
Colonna sys.dm_fts_memory_buffers:sys.dm_fts_memory_buffers column:

row_countrow_count
nessuna.None. dm_fts_memory_buffers.row_countdm_fts_memory_buffers.row_count 225225
Colonne sys.fulltext_catalogs:sys.fulltext_catalogs columns:

percorsopath

data_space_iddata_space_id

colonne file_idfile_id columns
nessuna.None. fulltext_catalogs.pathfulltext_catalogs.path

fulltext_catalogs.data_space_idfulltext_catalogs.data_space_id

fulltext_catalogs.file_idfulltext_catalogs.file_id
215215

216216

217217

Funzionalità non supportate in una futura versione di SQL ServerFeatures Not Supported in a Future Version of SQL Server

Le funzionalità seguenti di ricerca full-text sono supportate nella versione successiva di SQL ServerSQL Server, ma in seguito verranno rimosse.The following full-text search features are supported in the next version of SQL ServerSQL Server, but will be removed in a later version. La versione specifica di SQL ServerSQL Server non è stata determinata.The specific version of SQL ServerSQL Server has not been determined.

Il valore Nome funzionalità viene visualizzato negli eventi di traccia come nome dell'oggetto, mentre nei contatori delle prestazioni e in sys.dm_os_performance_counters viene visualizzato come nome dell'istanza.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. Il valore ID funzionalità viene visualizzato negli eventi di traccia come ID dell'oggetto.The Feature ID value appears in trace events as the ObjectId.

Funzionalità deprecataDeprecated feature SostituzioneReplacement Nome funzionalitàFeature name ID funzionalitàFeature ID
Operatore NEAR generico CONTAINS e CONTAINSTABLE:CONTAINS and CONTAINSTABLE generic NEAR operator:

{<simple_term> | <prefix_term>}{<simple_term> | <prefix_term>}

{{

{ { NEAR | ~ } {<simple_term> | <prefix_term>} } [...n]{ { NEAR | ~ } {<simple_term> | <prefix_term>} } [...n]

}}
Operatore NEAR personalizzato:The custom NEAR operator:

NEAR(NEAR(

{ {<simple_term> | <prefix_term>} [ ,…n ]{ {<simple_term> | <prefix_term>} [ ,…n ]

| ( {<simple_term> | <prefix_term>} [,…n] )| ( {<simple_term> | <prefix_term>} [,…n] )

[, [,] ][, [,] ]

}}

))

::= {integer | MAX} ::= {integer | MAX}

::= {TRUE | FALSE} ::= {TRUE | FALSE}
FULLTEXT_OLD_NEAR_SYNTAXFULLTEXT_OLD_NEAR_SYNTAX 247247
Opzione CREATE FULLTEXT CATALOG:CREATE FULLTEXT CATALOG option:

IN PATH 'rootpath'IN PATH 'rootpath'

ON FILEGROUP filegroupON FILEGROUP filegroup
nessuna.None. CREATE FULLTEXT CATLOG IN PATHCREATE FULLTEXT CATLOG IN PATH

nessuna.None.
237237

Nessuno.None.
Proprietà di DATABASEPROPERTYEX: IsFullTextEnabledDATABASEPROPERTYEX property: IsFullTextEnabled nessuna.None. DATABASEPROPERTYEX('IsFullTextEnabled')DATABASEPROPERTYEX('IsFullTextEnabled') 202202
Opzione di sp_detach_db:sp_detach_db option:

[ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'[ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'
nessuna.None. sp_detach_db @keepfulltextindexfile</span><span class="sxs-lookup">sp_detach_db @keepfulltextindexfile</span></span> 226226
Valori azione sp_fulltext_service: resource_usage non ha nessuna funzione.sp_fulltext_service action values: resource_usage has no function. NessunoNone sp_fulltext_service @action=resource_usage</span><span class="sxs-lookup">sp_fulltext_service @action=resource_usage</span></span> 200200

L'oggetto **SQL Server:Deprecated Features* non monitora le occorrenze di CREATE FULLTEXT CATLOG ON FILEGROUP filegroup.The **SQL Server:Deprecated Features* object does not monitor occurrences of CREATE FULLTEXT CATLOG ON FILEGROUP filegroup.