How do I check if stopwords are enabled on a full-text indexed table?

Question

I know how to enable them on my full text indexed table, but I don't know how to check if they are already enabled using an SQL command.

Can anyone shed some light on this?

`ALTER FULLTEXT INDEX ON SomeTable SET STOPLIST = OFF` to turn off. But I need to query to see if it's on or off. — NibblyPig, Dec 10 '13 at 14:41

score 3 · Accepted Answer · answered Dec 11 '13 at 20:17

3

Most of the fulltext-properties of a table can be queried by using the sys.fulltext_indexes dmv. In this case, stoplist_id should have the information you are looking for.

answered Dec 11 '13 at 20:17

aks

24,359
3
32
35

1

To add to this: sys.fulltext_indexes isn't very useful on its own, this connects it to more human friendly information: `select name, * from sys.fulltext_indexes as fullTextIndexes left join sys.objects as objects on objects.object_id = fullTextIndexes.object_id` – Richard Tingle Jun 26 '17 at 12:08

score 0 · Answer 2 · answered Dec 10 '13 at 16:44

0

you could try inserting a document containing only stop words, and then query it (pseudoquery: id=xxx AND text contains "the") - if you get a result, stopwords are being indexed (no stoplist). Hacky, but it will work.

answered Dec 10 '13 at 16:44

Mike Sokolov

6,914
2
23
31

How do I check if stopwords are enabled on a full-text indexed table?

2 Answers2