I have a SQL query which is using CONTAINS and is not finding recently created records that it should be finding, for example...
SELECT Id, Title
FROM Books
WHERE CONTAINS(Title, 'Frankenstein')
...should find...
Id_____Title
321____Frankenstein
Older records are being found.
I believe this may be related to a full text catalog, (present in SSMS under DB > Storage > Full Text Catalogs), which has the table as an object, and has the Title column ticked as an eligible column. "Track changes" is set to automatic. The "Last Population Date" is over a year ago. The "Population Status" is "Idle".
My understanding so far, (which may well be wrong), is that the CONTAINS searchable terms are being controlled by the full text catalog, therefore perhaps if I rebuild, or repopulate it, the record will be found? Could I even schedule this to happen automatically to prevent this problem in the future?
The "Repopulate catalog" option on the full text catalog is greyed out. The "Rebuild catalog" option is not greyed out. I am concerned about attempting to perform either operation without fully understanding what they do... could you explain? I have already read the material around this subject on MSDN.
Thanks.