-
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.
