O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Full-Text Search

Full-text search allows extensive word searches of textual data, and it is an additional component that you can add to the SQL Server installation. (For details, see the section titled "Adding Components and Instances" in Chapter 2.) After you install the full-text search component, you can manage full-text searches by using the methods described in the following sections.

Several administration tasks are required to utilize full-text search. You must:

  • Install the Full-Text Search component using SQL Server 2005 Setup.

  • Start the related service, which is called the Microsoft Search service, shown in the interface as msftesql.

  • Enable full-text search of the database using sp_fulltext_database enable.

  • Create a full-text ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required