December 6, 2002 at 2:30 pm
I am having trouble with a full text index on a text data type column. I have the index change tracking and update in background set on. It seems that if I insert a large amount of text into the column, the indexing process picks it up and it become part of the full text catalog. However, if i edit the text in the text data type column, for example I add a word in the middle of it, my new word does not show up in the catalog. What could be going on here? Is there something about the way text data type columns are handled that may cause this type of behaviour? It doesnt even seem to show up if I do full rebuild of the catalog. Help!
December 9, 2002 at 8:00 am
This was removed by the editor as SPAM
December 9, 2002 at 9:03 am
This sounds like a bug to me. I'd make sure you have the latest service pack applied. We have an app that repops its catalogs every 1/2 hour (if needed) to pick up changes to its columns. Most of our activity is insert but we don't see this problem with updates.
I just ran a test (have to wait 45 mins or so) and the update was picked up no problem.
Be sure your FT catalogs are correctly defined. And be sure you repop them. Other than that, I don't have any suggestion.
December 9, 2002 at 9:15 am
I found the answer to my problem. I have change tracking enabled and I am storing data in a text column. I did not have "text in row" option enabled which meant that change tracking could not track changes to that column. With "text in row" option set ON, it was able to. This was a case of RTFM.
Thanks to those that tried to help out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply