Full-Text Search in SQL Server 2005 Express Edition

This article explains how to perform Full Text searches using SQL Server 2005 Express Edition with Advanced Services.

SQL Server 2005 Express Edition with Advanced Services does have the capability to perform Full Text Searches, however, as this edition does not include SQL Server Agent functionality, you must perform Transact-SQL-based full-text search related tasks in the query editor in Management Studio Express.

The Template Explorer component that is included in Management Studio Express Edition contains the following full-text search related templates:

Create Full-text Catalog
Create Full-text Index
Start Full Population
Stop Population

These templates help accelerate full-text search related task generation.

To access these full-text search related templates, follow these steps:

Start SQL Server Management Studio Express Edition

Connect to the instance of SQL Server 2005 Express Edition.

On the View menu, click Template Explorer.

In Template Explorer, expand the Full-text folder. The full-text search related templates are in this folder.

To use the template, open a query editor in SSMSE. Then, drag the template from Template Explorer to the query editor.