Graphical User Interfaces

GUIs are simple and straightforward to use. This chapter shows how they fit into the rest of GUI for the SQL Server Enterprise Manager.

A. Console Pane

There are two full-text objects on the console (left) pane:

• Full-Text Search: A right-click brings up a menu that has options such as starting and stopping the full-text search service.
• Full-Text Catalogs: Selecting this causes a list of full-text catalogs for a database to be displayed in the details (right) pane. A right-click brings up a context menu that has options such as creating new full-text catalogs and rebuilding all the full-text catalogs for a database.

B. Tools Menu

Selecting Full-Text Indexing launches the Full-Text Indexing Wizard.

C. Context Menu of a Typical Table

The Full-Text Index Table menu option has suboptions that can be used to launch the Full-Text Indexing Wizard to define or to modify the full-text index specifications for a table or to remove full-text indexing from the table.

D. Property Sheet Tabs of a Typical Table

Selecting the Full-Text Indexing tab selects a property page. The illustration shows a typical page.

E. Catalog Pane and Context Menu

To view this menu follow these steps:

1. To view the list of full-text catalogs, select the Full-Text Catalogs object on the Console Pane A.
2. Right-click the fcp.northwind.ft.ctlg to view the context menu shown.

   Select Properties to view the Full-Text Catalog Properties dialog box.

F. Status Property Page

To view this property page, select Properties in the menu shown in E.

G. Schedules Property Page

To view this property page, select Schedules in the menu shown in E.

H. Full-Text Indexing Wizard

This wizard can be invoked from many places: The two ways we have shown here are by selecting the Full-Text Indexing… option from the Tools Menu B or one of the Full-Text Index Table options from the Context Menu C. The wizard gathers all the information necessary to create and maintain a full-text index for a given table.

Registering and activating a table does not mean that the full-text queries can be issued against the table. A full-text index must be created first, and this is not a function of the wizard. After registering one or more tables, start a full population of the full-text catalogs for those tables by selecting Start Population on the Pubs Catalog context menu.