Full-Text Search Concepts

Microsoft SQL Server 2005 contains the functionality you need to issue full-text queries against plain character-based data in Microsoft SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.

Topic Description

Introduction to Full-Text Search

Introduces you to terminology associated with Full-Text Search and other fundamentals and also provides you with a business scenario.

Full-Text Search Architecture

Describes the architecture of Full-Text Search and also describes the new Microsoft Full-Text Engine for SQL Server (MSFTESQL) service.

Administering Full-Text Search

Explains deployment and administration concepts associated with Full-Text Search.

Querying SQL Server Using Full-Text Search

Describes the different types of queries that you can run using Full-Text Search.

International Considerations for Full-Text Search

Provides information on how to specify a language when creating a full-text index and also lists the languages supported by Full-Text Search.

Troubleshooting Full-Text Search

Provides answers to frequently-asked questions and basic troubleshooting information.

Full-Text Search How-to Topics

Contains step-by-step instructions for performing various tasks with Full-Text Search.

Item Finder Sample

This sample application showcases the full-text features introduced in SQL Server 2005 using the new AdventureWorks sample database.