Using the Full-Text Indexing Wizard to Build Full-Text Indexes and Catalogs

Although the T-SQL full-text commands provide a scriptable interface for creating full-text catalogs and indexes, sometimes it is easier to use the Full-Text Indexing Wizard to create them. To create a full-text index, follow these steps:

1. Connect to SQL Server in SQL Server Management Studio.

2. Expand the databases folder.

3. Expand the database that contains the tables you want to full-text index.

4. Expand the tables folder.

5. Right-click the table you want to full-text index (in this example, the Production.Document table).

6. Select Full-Text Index, as shown in Figure 50.1.

Figure 50.1 Selecting the Full-Text Index menu in SSMS.

You then click Define Full-Text ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.