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 51.5.
FIGURE 51.5 Selecting the Full-Text Index menu in SSMS.
You then click Define Full-Text ...
Get Microsoft® SQL Server 2012 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.
