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.