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
In Object Explorer, expand the server.
Expand Databases, and then expand the database that contains the full-text index.
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.
In the Select a page pane, you can select any of the following pages:
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
For more information, see Full-Text Index Properties (General Page).
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).
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).ImportantAfter 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).
Click OK. to save any changes and exit the Full-text index Properties dialog box.