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

Managing Full-Text Catalogs

Each database that you want to search must have its own full-text catalog. When you create a catalog, you can set a schedule for populating the catalog on a regular basis, or you elect to manually populate the catalog as necessary. Populating the catalog updates the full-text indexes for the catalog and ensures that the search results are accurate. SQL Server supports several methods for populating catalogs including:

  • Full population. The search service builds index entries for all rows in all the tables or views covered by the full-text catalog. In most cases, you perform a full population only when you create a catalog or need to refresh the entire contents of a catalog.

  • Incremental population. The search service only ...

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