Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Specify the owner of the full-text stoplist. If you want ownership to be assigned to yourself, that is, to the current user, leave this field empty.
To specify a different user, click the browse button.
Create stoplist options
Click one of the following create options:
Create an empty stoplist
The new stoplist will not contain any stopwords.
Create from the system stoplist
The new stoplist is created from the stoplist that exists by default in the Resource database.
Create from an existing full-text stoplist
The new stoplist is created by copying an existing stoplist.
Specifies the name of the database to which the existing stoplist belongs. The current database is selected by default. Optionally, select a different database from the list box.
Specifies the name of an existing stoplist. From the list of available stoplists, select the one to use as the source. The available stoplists are listed in the order in which they appear in Object Explorer.
If any languages specified in the stop words of the source stoplist are not registered in the current database, CREATE FULLTEXT STOPLIST succeeds, but warning(s) are returned and the corresponding stop words are not added.