TechNet Home > Products and Technologies > SQL TechCenter Home > SQL Server 2005 > Technologies

SQL Server 2005 – Full-Text Search

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

SQL Server Full-Text Search InfoCenters

InfoCenters are navigation topics in the SQL Server 2005 Books Online that link to the information that is most important for people working with SQL Server Full Text in different roles.

•	Roles and InfoCenters

•	Full-Text Search Administrator InfoCenter

•	Full-Text Search Developer InfoCenter

Getting Started

Find Full-Text Search overviews, installation instructions, introductions, fundamentals, and more.

•	Full-Text Search Overview

•	Full-Text Search Enhancements

•	Installing and Upgrading Full-Text Search

•	Introduction to Full-Text Search

•	Full-Text Search Fundamentals

•	SQL Server 2005 Full-Text Search: Internals and Enhancements

Planning and Architecture

Use these articles and white papers to better understand Full-Text Search and plan to use it to issue full-text queries against your data.

•	Full-Text Search Architecture

•	Full-Text Search Concepts

•	International Considerations for Full-Text Search

Development

Find the information developers require to build Full-Text indexes use them in enhanced keyword-based queries of text data stored in Microsoft SQL Server databases.

•	Full-Text Data Definition Language (DDL)

•	Creating Full-Text Indexes

•	Attach and Detach Full-Text Catalogs

•	Querying SQL Server Using Full-Text Search

•	Inquiring About the Full-Text Key Column

Deployment

Plan for the deployment of Full-Text Search.

•	Installing and Upgrading Full-Text Search

•	Full-Text Search Backward Compatibility

Operations

Learn about SQL Server 2005 Full-text Search administration and operations tasks such as backup, restore, and monitoring for performance and system heath.

•	Administering the Full-Text Search

•	Performance Tuning and Optimization (Full-Text Search)

•	Querying SQL Server Using Full-Text Search

•	Troubleshooting the Full-Text Search

Toolbox

•

SQL Server Full-Text Search Tools

•	SQL Server 2005 Upgrade Advisor
•	SQL Server 2005 Books Online
•	SQL Server 2005 Samples

Search Links

•	Search SQL Server Newsgroups

•	Search the Microsoft Knowledge Base

For More Information

Can’t find what you are looking for? Explore the resources on:

•	SQL Server 2005 Support Center on the Microsoft Help and Support site

•	SQL Server Developer Center on MSDN

•	SQL Server Product Site

•	SQL Server 2005 Technical Documentation Library

Top of page