Configuring Full-Text Catalogs and Indexes for a Database

Configuring a user database for full-text search involves creating one or more full-text catalogs for the database and defining a full-text index on each table or indexed view on which you want to execute full-text queries.


In SQL Server 2008, all databases are full-text enabled.

At the database level, full-text administration covers the following activities:

  • Creating full-text catalogs and indexes.

  • Altering existing full-text catalogs and indexes. For example, you can create and drop the metadata for one of more full-text catalogs. At the table level, you can enable or disable a table or indexed view for full-text search. At the column level, you can add or drop columns that support full-text queries.

  • Scheduling and maintaining full-text index populations. After adding or dropping a column, you will need to repopulate the associated full-text catalog. Repopulating can be done when you add the column, or it can be delayed and performed either manually or by job runs a scheduled population on the full-text index. Repopulating synchronizes the full-text index of the table with new data in full-text indexed columns.

  • Dropping existing full-text catalogs and indexes.

Full-Text Indexing Overview

Introduces full-text indexes and contains information about creating, altering, and dropping them.

Getting Started with Full-Text Search

Describes the basic steps for setting up full-text search on a database.

Best Practices for Choosing a Language When Creating a Full-Text Index

Discusses considerations for specifying the language when creating a full-text index on a table column.

Full-Text Catalog and Index Properties (Transact-SQL)

Lists the full-text properties of a database that are useful in SQL Server 2008 and the Transact-SQL function that returns each property.

Performance Tuning and Optimization of Full-Text Indexes

Discusses recommendations to increase full-text index performance.

Full-Text Catalog and Index How-to Topics (Full-Text Search)

Contains step-by-step instructions for performing various tasks with full-text catalogs and indexes.

Community Additions