Microsoft® SQL Server™ 2000 Unleashed, Second Edition

Setting Up a Full-Text Index

You can set up a full-text index using system-stored procedures (including sp_fulltext_database, sp_fulltext_table, and so on), or through the SQL Enterprise Manager. The examples here demonstrate how to set up an index using the Enterprise Manager.

Suppose you are working on a project for a technical recruiting firm that wants to have a searchable database of candidate résumés. You have a table called resume, with the following definition:

create table resume( 
       resume_id int identity
              constraint PK_resume primary key clustered,
        contact_id int not null
               constraint FK_resume_contact references contact,
        submitDT datetime not null default CURRENT_TIMESTAMP,
       res_text text null
       )

In the preceding definition, contact_id ...