Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

How to: View or Change the Properties of a Full-Text Index (SQL Server Management Studio)

To view or change the properties of a full-text index

  1. In Object Explorer, expand the server.

  2. Expand Databases, and then expand the database that contains the full-text index.

  3. Expand Tables.

  4. Right-click the table on which the full-text index is defined, select Full-Text index, and on the Full-Text index context menu, click Properties. This opens the Full-text index Properties dialog box.

  5. In the Select a page pane, you can select any of the following pages:

    Page

    Description

    General

    Displays basic properties of the full-text index. These include several modifiable properties and a number of unchangeable properties such as database name, table name, and the name of full-text key column. The modifiable properties are:

    • Full-Text Index Stoplist

    • Full-Text Indexing Enabled

    • Change Tracking

    For more information, see Full-Text Index Properties (General Page).

    Columns

    Displays the table columns that are available for full-text indexing. The selected column or columns are full-text indexed. You can select as many of the available columns as you want to include in the full-text index. For more information, see Full-Text Index Properties (Columns Page).

    Schedules

    Use this page to create or manage schedules for a SQL Server Agent job that starts an incremental table population for the full-text index populations. For more information, see How to: Create or Manage a Schedule for Incremental Populations of a Full-Text Index (SQL Server Management Studio).

    Important noteImportant
    After you exit the Full-Text Index Properties dialog box, any newly created schedule is associated with a SQL Server Agent job (Start Incremental Table Population on database_name.table_name).

  6. Click OK. to save any changes and exit the Full-text index Properties dialog box.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.