Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2012 Property Editors › Define a SQL Server 2012 Full-Text Stoplist

Define a SQL Server 2012 Full-Text Stoplist

Full-text stoplists are used on full-text indexes so that no strings are searched in the stoplist by a full-text query, and the index is not populated with any tokens that are part of the stoplist. A stopword defines each string in the stoplist. Each word can be associated with a language.

Use the SQL Server Fulltext Stoplist Editor in a SQL Server 2012 physical model to define a list of strings to omit from a full-text index.

To define a SQL Server full-text stoplist

1. Click Target - SQL Server, Fulltext Stoplists on the Model menu.

   The SQL Server Fulltext Stoplist Editor opens.

2. Select the full-text stoplist in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new full-text stoplist. Use the Enter filter text box to filter a very large list of full-text stoplists to quickly locate the one that you want to define.

   Name

   Specifies the name of the full-text stoplist. Change the name of the full-text stoplist in this field.

   Stop List

   Specifies to create a new stoplist by copying the existing stoplist selected in this drop-down.

   Note: The system stoplist exists by default.

   Authorization

   Specifies the database principal object that owns the full-text stoplist.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the StopWord tab to specify the stopwords to use in the full-text stoplist, and the language to associate with each stopword.
4. (Optional) Click the Comment tab and enter any comments that you want to associate with the full-text stoplist.
5. (Optional) Click the Where Used tab to view where the full-text stoplist is used in the model.
6. (Optional) Click the UDP tab to work with user-defined properties for the full-text stoplist.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The full-text stoplist is defined and the SQL Server Fulltext Stoplist Editor closes.