Export (0) Print
Expand All

Full-Text Search and Semantic Search Stored Procedures (Transact-SQL)

SQL Server supports the following system stored procedures that are used to implement and query full-text indexes and semantic indexes.

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.

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. 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.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER FULLTEXT INDEX instead.

sp_fulltext_database

Has no effect on full-text catalogs in SQL Server 2008 and later versions and is supported for backward compatibility only.

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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.

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. 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.

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. 

sp_help_fulltext_catalogs

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

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sys.fulltext_catalogs catalog view instead.

sp_help_fulltext_columns

Returns the columns designated for full-text indexing.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sys.fulltext_indexes catalog view instead.

sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)

Registers a pre-populated Semantic Language Statistics database in the current instance of SQL Server.

sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)

Unregisters an existing Semantic Language Statistics database from the current instance of SQL Server and deletes any associated metadata.

Community Additions

ADD
Show:
© 2014 Microsoft