This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 89%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
We need to update the indexes by rebuilding the full text catalog for a frequently for our search to work.
right now as we are in development we just do manual rebuild of the catalag in Management Studio.
but we want to do it programatically, so what are our options?
We are planning to launch a job that rebuild the full text catalog every N minutes or something.
Is this a good approach?
or I am planning to have a trigger that triggers the rebuild of catalog when an insert happened.
but first, i want to know
Lastly, what are my other options aside from doing it in trigger or job?
It's not clear to me why you would need to do this. The default when you create a fulltext index is CHANGE_TRACKING = AUTO, which means that SQL Server will update the index automatically.
Observe though, that in difference to regular indexes, fulltext indexes are updated asynchronously, so changes are not visible immediately, but there can be a delay.
Thank you for your anser, the thing is we just took over the project and it seems like the search is not working properly because the indexes are not rebuild with new data inserted to some tables, so we do manual rebuild everytime to do it, thankfully we are still in staging stage and we are looking for a way to automate this.
the thing is when i checked the Full Text Catalog window, it is already set to Automatic to track changes
So what we are doing now is to schedule a Windows Task Scheduler (since we are using SQL server express) that rebuilds the full text catalog once a day.
So I am confuse what is happening here;
Beware the the change-tracking setting is per index, not per fulltext catalog.
You can view the setting for for all fulltext indexes with this query:
SELECT object_name(object_id), * FROM sys.fulltext_indexes
This view also includes the column is_crawl_completed, which tells if an update is in progress or not.
I don't the full story on how often a crawl starts and when it completes, but it should be more than once a day.
And it should not make that much difference if it is Express Edition.