SQL Server 2016에서 사용되지 않는 전체 텍스트 검색 기능Deprecated Full-Text Search Features in SQL Server 2016

이 항목에서는 SQL Server에서 계속 제공되지만 더 이상 사용되지 않는 전체 텍스트 검색 기능에 대해 설명합니다.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.

SQL Server:Deprecated Features 개체 성능 카운터 및 추적 이벤트를 통해 더 이상 사용되지 않는 기능의 사용을 모니터합니다.Monitor your use of deprecated features by using the SQL Server:Deprecated Features object performance counter and trace events. 자세한 내용은 SQL Server 개체 사용을 참조하세요.For more information, see Use SQL Server Objects.

더 이상 지원되지 않는 기능Features no longer supported

사용되지 않는 기능Deprecated feature 대체 기능Replacement 기능 이름Feature name 기능 IDFeature ID
FULLTEXTCATALOGPROPERTY 속성: LogSizeFULLTEXTCATALOGPROPERTY property: LogSize 없음None. FULLTEXTCATALOGPROPERTY('LogSize')FULLTEXTCATALOGPROPERTY('LogSize') 211211
FULLTEXTSERVICEPROPERTY 속성:FULLTEXTSERVICEPROPERTY property:

ConnectTimeoutConnectTimeout

DataTimeoutDataTimeout
없음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 동작 값: clean_up, connect_timeout 및 data_timeout은 0을 반환합니다.sp_fulltext_service action values: clean_up, connect_timeout, and data_timeout return zero 없음None 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
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

상태status

status_descriptionstatus_description

worker_countworker_count
없음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
sys.dm_fts_memory_buffers 열:sys.dm_fts_memory_buffers column:

row_countrow_count
없음None. dm_fts_memory_buffers.row_countdm_fts_memory_buffers.row_count 225225
sys.fulltext_catalogs 열:sys.fulltext_catalogs columns:

pathpath

data_space_iddata_space_id

file_id 열file_id columns
없음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

이후 버전의 SQL Server에서 지원되지 않는 기능Features Not Supported in a Future Version of SQL Server

아래 전체 텍스트 검색 기능은 다음 버전의 SQL ServerSQL Server에서 지원되지만 이후 버전에서는 제거될 예정입니다.The following full-text search features are supported in the next version of SQL ServerSQL Server, but will be removed in a later version. 어떤 버전의 SQL ServerSQL Server 에서 제거될지는 결정되지 않았습니다.The specific version of SQL ServerSQL Server has not been determined.

기능 이름 값은 추적 이벤트에는 ObjectName으로 표시되고 성능 카운터 및 sys.dm_os_performance_counters에는 인스턴스 이름으로 표시됩니다.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. 기능 ID 값은 추적 이벤트에 ObjectId로 표시됩니다.The Feature ID value appears in trace events as the ObjectId.

사용되지 않는 기능Deprecated feature 대체 기능Replacement 기능 이름Feature name 기능 IDFeature ID
CONTAINS 및 CONTAINSTABLE 일반 NEAR 연산자: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]

}}
사용자 지정 NEAR 연산자: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
CREATE FULLTEXT CATALOG 옵션:CREATE FULLTEXT CATALOG option:

IN PATH 'rootpath'IN PATH 'rootpath'

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

없음None.
237237

없음None.
DATABASEPROPERTYEX 속성: IsFullTextEnabledDATABASEPROPERTYEX property: IsFullTextEnabled 없음None. DATABASEPROPERTYEX('IsFullTextEnabled')DATABASEPROPERTYEX('IsFullTextEnabled') 202202
sp_detach_db 옵션:sp_detach_db option:

[ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'[ @keepfulltextindexfile = ] 'KeepFulltextIndexFile'
없음None. sp_detach_db @keepfulltextindexfile</span><span class="sxs-lookup">sp_detach_db @keepfulltextindexfile</span></span> 226226
sp_fulltext_service 동작 값: resource_usage는 아무 기능도 수행하지 않습니다.sp_fulltext_service action values: resource_usage has no function. 없음None sp_fulltext_service @action=resource_usage</span><span class="sxs-lookup">sp_fulltext_service @action=resource_usage</span></span> 200200

SQL Server:Deprecated Features* 개체는 CREATE FULLTEXT CATLOG ON FILEGROUP filegroup의 발생을 모니터링하지 않습니다.*The **SQL Server:Deprecated Features object does not monitor occurrences of CREATE FULLTEXT CATLOG ON FILEGROUP filegroup.