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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.
