July 14, 2016 at 3:14 pm
New values are added to a table through an application by end users. When a new value is added to the underlying table, the index is not updating to include the new value. When a search is performed in the application for the new value, it does not show up unless the index is re-created manually. The index is not disabled so I was under the impression that the index should be updating automatically when the column(s) with the index is added to or updated. Change Tracking is turned on for the database & table. There is a weekly schedule that runs every Monday morning to run a FULL update on the index, but it only adds in new values half the time, so there are Pending changes that still require me to manually drop/recreate the index. After this, the new value shows up in the search in the user application.
The second part of my question is how do I see what permissions exist on the index? I would think that there would be a table somewhere that holds records of existing permissions for the index.Thanks in advance for your help.
July 17, 2016 at 1:01 am
Check that for all columns in the catalog, track changes is set to Automatic rather than Manual or Do Not Track,
Secondly, for the index set up a schedule, if one does not exist, to repopulate at a suitable time interval; this will be determined by how often things change.
Permissions will be determined by user permissions granted to the underlying table/view within the catalog.
...
July 18, 2016 at 1:16 pm
Thank you very much! I checked and the full-text index Change Tracking was set to Automatic, but I read some more and realized that neither the Database nor the table affected had Change Tracking set to 'True'. I will change these settings and see if that makes a difference.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply