Export (0) Print
Expand All

Select Catalog, Index Filegroup, and Stoplist (Full-Text Indexing Wizard)

To start the Full-Text Indexing Wizard

Select full-text catalog

Select a full-text catalog from the list. The default catalog for the database will be the selected item by default in the list. If no catalogs are available, the list will be disabled, and the Create a new catalog checkbox will be checked and disabled.

Create a new catalog

Select to create a new full-text catalog.

Name

Enter a name for the new full-text catalog.

Set as default catalog

Select to make the catalog the default for this database.

Accent sensitivity

Specify whether the new catalog will be accent-sensitive or accent-insensitive. If the database is accent-sensitive, Sensitive will be selected by default.

Select index filegroup

Specify the filegroup on which to create the full-text index.

Select one of the following values:

Value

Description

<default>

If the table or view is not partitioned, select to use the same filegroup as the underlying table or view. If the table or view is partitioned, the primary filegroup is used.

PRIMARY

Select to use the primary filegroup for the new full-text index.

user-specified default filegroup

If a user-defined default stoplist exists, select its name from the list to use that filegroup for the new full-text index.

Select full-text stoplist

Specify a stoplist to use for the full-text index, or disable stoplist use.

In SQL Server 2008 and later versions, stopwords are managed in databases using objects called stoplists. A stoplist is a list of stopwords that, when associated with a full-text index, is applied to full-text queries on that index. For more information, see Stopwords and Stoplists.

Select one of the following values:

Value

Description

<system>

Select to use the system stoplist on the new full-text index. This is the default

<off>

Select to disable stoplists for the new full-text index.

user-defined-stoplist-name

The list displays the name of each user-defined stoplist, if any, that has been created on the database. Select any user-defined stoplist to use for the new full-text index.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft