Hi,
I have a table setup running full-text index in sql server 2000. After
finishing 12 hrs long of initial full population, I immediately turned on the
"change tracking, update index in background". The full text index population
restart all over again even though there is no data change after that initial
full population. Could someone shed some light on this?
thanks,
-Leon
This is a known problem. I reported it to Microsoft I believe 3 years ago.
"Leon Lee" <Leon Lee@.discussions.microsoft.com> wrote in message
news:8425F683-75BB-44B6-9918-25E6781ABF32@.microsoft.com...
> Hi,
> I have a table setup running full-text index in sql server 2000. After
> finishing 12 hrs long of initial full population, I immediately turned on
> the
> "change tracking, update index in background". The full text index
> population
> restart all over again even though there is no data change after that
> initial
> full population. Could someone shed some light on this?
> thanks,
> -Leon
Sunday, February 19, 2012
After switch to "Change tracking", full-text index repopulate in f
Labels:
afterfinishing,
database,
full-text,
hrs,
immediately,
index,
initial,
microsoft,
mysql,
oracle,
population,
repopulate,
running,
server,
setup,
sql,
switch,
table,
tracking,
turned
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment