RSS

Forums/Tips & Tricks

Creating the Full-text Index for DynamicPolicy Documents

Zequel Support
posted this on Sep 28, 2009 13:02

 

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