sql - Why my full text catalogue does not return All values Possible?

Question

I have a full text catalogue on one of my databases and all the needed options are set correctly, when I rebuild my FTC I can see all of my possible values but after sometime they disappear and just some values before an specific time can be seen in my report then I need to rebuild my FTC again. I have tried to change the track Changes Into manual then automatic and save it but it did not help, and my tables index track option is also in Automatic mode and I can see that the crawl end date changes by the time but still the problem exist. I would be appreciate If I could know the possible missing option or setting.

question from:https://stackoverflow.com/questions/65880938/why-my-full-text-catalogue-does-not-return-all-values-possible

Answer 1

Waitting for answers