Full-Text Search Stored Procedures (Transact-SQL)

SQL Server 2008 supports the following system stored procedures that are used to implement and query full-text 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.