I have trouble with full text search in one database running on SQL 2005 Express SP2 server. When I run this query:
It returns me correct result, but RANK column is 0 for all rows. I read some forums and I try first to Rebuild Catalog. After rebuild catalog, I get correct result:
but after let's say 5 queries or 1 minute I got again this:
As u can see, records are same, but because RANK = 0, order of records is lost, so I can't make ORDER BY RANK.
I tried to set pre-compute rank:
Setting it ON or OFF change nothing. Still same scenario. After few queries or time (i'm more sure about time) all RANK get reset to 0.
I have 2 other databases running on this server and they have no trouble with lost rank number. Each database have own full text catalog.
I tried re-create catalog, set pre-compute rank, nothing helps. Only rebuild fix it but only for short time (1 minute).
Here are full text catalog settings (I copy it all from properties tab in SQL Management Studio):
Track changes I have set AUTO
and I have no population schedule set.
Fixed by creating dummy table and index it as well. Look here:
- Marked as answer by Pavel Valenta Monday, February 02, 2009 1:44 AM