Full Text Search - Auto Change Tracking

Id like to know a bit about the behaviour of CHANGE_TRACKING AUTO, specifically when the update of the index takes place. In the docs it states 'these changes may not be reflected immediately' but in general when can the changes be expected to appear. Is there merit to updating manually, although the user needs ALTER permission on the table in that case vs. letting SQL Server run it automatically.

Thanks for any help - MikeIn case you or anyone else has found any relevant information about this topic I'd also be interested to hear about it since the documentation doesn't really clear things up.

kind regards,
heinz

Full Text Search - Auto Change Tracking

Id like to know a bit about the behaviour of CHANGE_TRACKING AUTO, specifically when the update of the index takes place. In the docs it states 'these changes may not be reflected immediately' but in general when can the changes be expected to appear. Is there merit to updating manually, although the user needs ALTER permission on the table in that case vs. letting SQL Server run it automatically.

Thanks for any help - Mike
In case you or anyone else has found any relevant information about this topic I'd also be interested to hear about it since the documentation doesn't really clear things up.

kind regards,
heinz

fts catalog size

I am new to using FTS for searching, so please forgive the ignorance if there is an obvious answer. I've set up a table specifically to hold searchable data rather than have a number of table joins for searching. I've imported about 1/4 of the data into the table and set up a catalog on the table. The catalog is currently 62 mb. Is there a suggested limit to a catalog size for FTS and if so, is there a way to set up a catalog so that when it reaches this size, it splits off and creates a 2nd catalog? Thanks.No you can't throttle the size, nor can you have another catalog created dynamically. Note that a full text index for a table can't span catalogs, ie one index one catalog. -- 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 wrote in message news:ec61e74c-e1b9-4f40-a99c-0c7ada543225@.discussions.microsoft.com... I am new to using FTS for searching, so please forgive the ignorance if there is an obvious answer. I've set up a table specifically to hold searchable data rather than have a number of table joins for searching. I've imported about 1/4 of the data into the table and set up a catalog on the table. The catalog is currently 62 mb. Is there a suggested limit to a catalog size for FTS and if so, is there a way to set up a catalog so that when it reaches this size, it splits off and creates a 2nd catalog? Thanks.