I have a table with a full-text index that is essentially a denormalized view of several tables that is automatically updated when any of the base tables are updated via triggers. This table is primarily used for a nightly operation, but I would like to use it for more real-time things if I could only get the population figured out.
When setting up the full-text index, I set 'track changes' to 'Automatic' as I didn't want have to fully populate the index every night. However, it doesn't seem to incorporate newly added records for some time, if at all. I can only get new records to return in FREETEXTTABLE query by re-building the index.
I tried setting up a population schedule twice a day, but that doesn't seem to do anything. I am testing it by looking at newly inserted records in the base tables and searching for them in a FREETEXTTABLE query, expecting the correct ID to show up in the search results.
When researching online, I kept seeing 'populate in background' as a potential solution, but I never saw anything about how to actually enable this.
Any ideas?