Full Text System Views
Posted in Full Text Search, iFTS, tagged fts, fulltext_index_fragments, fulltext_stoplists, fulltext_stopwords, iFTS, Katmai, STOPLIST, stoplists, stopword, stopwords on April 20, 2008 | No Comments »
Here is a summary of the new Full Text System Views in SQL 2008.
sys.fulltext_stoplists
A list of STOPLISTS in your database. STOPLISTS are database specific. STOPLISTS replace Noise Word Files.
sys.fulltext_stopwords
This will show you you’re STOPWORDS. You can filter this on the language and or stoplist of your choice. STOPWORDS are individual words that make up a [...]