full-text-search-and-semantic-search-stored-procedures-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Full-Text Search and Semantic Search stored procedures (Transact-SQL)	Full-Text Search and Semantic Search stored procedures (Transact-SQL)	markingmyname	maghan	randolphwest	08/21/2024	sql	system-objects	reference	full-text indexes [SQL Server], stored procedures full-text search [SQL Server], stored procedures full-text catalogs [SQL Server], stored procedures system stored procedures [SQL Server], full-text search	TSQL

Full-Text Search and Semantic Search stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] supports the following system stored procedures that are used to implement and query full-text indexes and semantic indexes.

Full-Text Search stored procedures

• sp_fulltext_catalog

  Creates and drops a full-text catalog, and starts and stops the indexing action for a catalog. Multiple full-text catalogs can be created for each database.

  [!INCLUDE ssNoteDepFutureAvoid] Use CREATE FULLTEXT CATALOG, ALTER FULLTEXT CATALOG, and DROP FULLTEXT CATALOG instead.

• sp_fulltext_column

  Specifies whether or not a particular column of a table participates in full-text indexing.

  [!INCLUDE ssNoteDepFutureAvoid] Use ALTER FULLTEXT INDEX instead.

• sp_fulltext_database

  Has no effect on full-text catalogs in [!INCLUDE sql2008-md] and later versions and is supported for backward compatibility only.

  [!INCLUDE ssNoteDepFutureAvoid]

• sp_fulltext_keymappings

  Returns mappings between document identifiers (DocIds) and full-text key values.

• sp_fulltext_load_thesaurus_file

  Parses and loads the data from an updated thesaurus file that corresponds to an LCID and causes recompilation of full-text queries that use the thesaurus.

• sp_fulltext_pendingchanges

  Returns unprocessed changes, such as pending inserts, updates, and deletes, for a specified table that is using change tracking.

• sp_fulltext_service

  Changes the server properties of full-text search for SQL Server.

• sp_fulltext_table Marks or unmarks a table for full-text indexing.

  [!INCLUDE ssNoteDepFutureAvoid] Use CREATE FULLTEXT INDEX, ALTER FULLTEXT INDEX, and DROP FULLTEXT INDEX instead.

• sp_help_fulltext_catalog_components

  Returns a list of all components (filters, word-breakers, and protocol handlers), used for all full-text catalogs in the current database.

  [!INCLUDE ssNoteDepFutureAvoid]

• sp_help_fulltext_catalogs

  Returns the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.

  [!INCLUDE ssNoteDepFutureAvoid] Use the sys.fulltext_catalogs catalog view instead.

• sp_help_fulltext_catalogs_cursor

  Uses a cursor to return the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.

  [!INCLUDE ssNoteDepFutureAvoid] Use the sys.fulltext_catalogs catalog view instead.

• sp_help_fulltext_columns

  Returns the columns designated for full-text indexing.

  [!INCLUDE ssNoteDepFutureAvoid] Use the sys.fulltext_index_columns catalog view instead.

• sp_help_fulltext_columns_cursor

  Uses a cursor to return the columns designated for full-text indexing.

  [!INCLUDE ssNoteDepFutureAvoid] Use the sys.fulltext_index_columns catalog view instead.

• sp_help_fulltext_system_components

  Returns information for the registered word-breakers, filter, and protocol handlers, as well as a list of identifiers of databases and full-text catalogs that have used a specified component.

• sp_help_fulltext_tables

  Returns a list of tables that are registered for full-text indexing.

• sp_help_fulltext_tables_cursor

  Returns a list of tables that are registered for full-text indexing.

  [!INCLUDE ssNoteDepFutureAvoid] Use the sys.fulltext_indexes catalog view instead.

Semantic Search stored procedures

• sp_fulltext_semantic_register_language_statistics_db

  Registers a pre-populated Semantic Language Statistics database in the current instance of [!INCLUDE ssNoVersion].

• sp_fulltext_semantic_unregister_language_statistics_db

  Unregisters an existing Semantic Language Statistics database from the current instance of [!INCLUDE ssNoVersion] and deletes any associated metadata.

Related content

• Full-Text Search and Semantic Search Catalog Views (Transact-SQL)
• Full-Text and Semantic Search Dynamic Management Views - Functions
• System stored procedures (Transact-SQL)
• Full-Text Search