Hi,
I have the following setup. Full population works fine on a table with
53 rows, unique pk etc. but when i turn change tracking and background
index update on the FTI is not updated. Any thought are much
appreciated! -THanks, Dave

SELECT @@Version returns:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

running windows 2000 sp4


All these return 1:
SELECT OBJECTPROPERTY
(object_id('tblfiles'),'TableHasActiveFulltextInde x')
SELECT OBJECTPROPERTY
(object_id('tblfiles'),'TableFullTextBackgroundUpd ateIndexOn')
SELECT OBJECTPROPERTY
(object_id('tblfiles'),'TableFullTextChangeTrackin gOn')

anything in the gatherer logs?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



<dfateman (AT) gmail (DOT) com> wrote