Consider the following scenario. You install Microsoft SQL Server 2005 Express Edition with Advanced Services. You select Full-Text Search
during the installation. In this scenario, the following items that relate to full-text search are unavailable in the SQL Server Management Studio Express (SSMSE) user interface (UI):
- The Storage folder under a database folder
- The Full Text Index command in a table shortcut menu
This article describes how to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services.
SQL Server 2005 Express Edition with Advanced Services does not include SQL Server Agent functionality. Full-text search related tasks in the SSMSE UI require this functionality. However, you can perform Transact-SQL-based full-text search related tasks in the query editor in SSMSE.
The Template Explorer component that is included in SSMSE 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 SSMSE.
- 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.
For more information about the Transact-SQL statements that you can use to create and manage full-text catalogs and indexes, visit the following Microsoft Developer Network (MSDN) Web site: