CODEWITHSUNDEEP
sql-serverfull-text-search
Jonathan Allen
Jonathan Allen

Reputation: 70307

Which stoplist am I using?

How do I determine which stoplist was associated with my full text index?

Upvotes: 0

Views: 42

Answers (1)

Pரதீப்
Pரதீப்

Reputation: 93724

Try this.

SELECT FI.fulltext_catalog_id,
       FI.stoplist_id,
       FS.stopword
FROM   sys.fulltext_indexes FI
       LEFT JOIN sys.fulltext_stopwords FS
         ON fi.stoplist_id = fs.stoplist_id

Note: Selected information is available in sys.fulltext_stopwords table but to get the other info related fulltext_catalog joined fulltext_indexes table

Upvotes: 1

Related Questions