Forums/Tips & Tricks

Creating the Full-text Index for DynamicPolicy Documents

Zequel - Support
posted this on September 28, 2009 01:02 pm

 

Under SQL Server Enterprise Manager, please select the dynamic_policy database. Then under Tool, select Full-text indexing and follow the wizard:

 

  1. Select the policy table.

  2. Select the default unique key name

  3. Select the policy_description column

  4. Select the default catalog or create a new one

  5. Press Finish

  6. Under the dynamic_policy table, select the Full-Text catalog. Right-click under the text index and Select "Start Full-text Population"

 

fulltext_creation.jpg

 

 

To determine if the population has completed, right-click the name of your catalog, and then click Properties. This dialog box is displayed:

 

fulltext_catalog.jpg

 

Continue to click the Refresh button until the Status text box contains the word "Idle."

 
Topic is closed for comments