Microsoft SQL Server Full-Text Indexing Instructions

Change Tracking
(MSSQL Server 2000 Only)
The following is done using Microsoft Enterprise Manager included with Microsoft SQL Server:

  • Right-click the docs table in the Enterprise Search database
  • Click Change Tracking (to enable it) under the Full-Text Index Table sub-menu
  • Right-click the docs table again
  • Click on Update Index In Background (to enable it) under the Full-Text Index Table sub-menu

Schedule
The following is done using Microsoft Enterprise Manager included with Microsoft SQL Server:

  • Right-click the docs table in the Enterprise Search database
  • Click Schedules within the Full-Text Index Table sub-menu
  • Click New Table Schedule
  • Give it a name
  • Select Incremental population under Job type
  • Select Recurring under Schedule frequency
  • Click the Change button
  • Select Daily under Occurs
  • Select the time you want the schedule to run at Occurs once at under Daily frequency
  • Click the OK button to save the schedule frequency
  • Click the OK button once back at the previous screen to save the schedule
  • Finally, click the OK button again

Within Enterprise Search
The following is done within Enterprise Search:

  • Select the Database drop-down menu
  • Click Start Full Population under the Full-Text Index sub-menu or
  • Click Start Incremental Population

or

  • Enable "Automatically start incremental population" in the Options under the Indexing tab. This will instruct the spider to automatically trigger the incremental population after the spider has finished indexing. This option is set per collection.

Full Population will index all documents.
Incremental Population will only index documents that have changed, were added, or were removed.

Please note, that for incremental population to work, you must have a timestamp column in your docs table. If you do not have one, you can either create it giving it the name ts or by downloading the updated innerprise.sql SQL Script to re-create the Enterprise Search database (your existing index data will be lost if you chose this method).


 

 

Privacy Policy | Contact Innerprise
Copyright © 2004 Innerprise. All Rights Reserved.