Hello
I am getting some strange results after creating a full text index on a column.
The results returned from a CONTAINS search against the column first found ZERO results when I knew that this was incorrect I REBUILT the full text search. I then got back 7 results and after re-building again I received 17 records.
What is going on here? Can anyone help? I just don't get it. Surely when an full text search is created on a column, I should not have to keep re-building it? There are no errors when the search is created or when the results are returned. There are also no errors in the event log.
Can anyone advise?
Thanks in advance.