change tracking, update in background not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dfateman@gmail.com - 19 Jul 2006 23:23 GMT

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'),'TableHasActiveFulltextIndex')
SELECT OBJECTPROPERTY
(object_id('tblfiles'),'TableFullTextBackgroundUpdateIndexOn')
SELECT OBJECTPROPERTY
(object_id('tblfiles'),'TableFullTextChangeTrackingOn')

Reply to this Message

Hilary Cotter - 20 Jul 2006 02:00 GMT

anything in the gatherer logs?

Signature

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

> Hi,
> I have the following setup. Full population works fine on a table with
[quoted text clipped - 16 lines]
> SELECT OBJECTPROPERTY
> (object_id('tblfiles'),'TableFullTextChangeTrackingOn')

Reply to this Message