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.
In This Section
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.