Is there a way to get know about when the full-text index is updated and ready for use after an insert or update statement occured in a table on which automatic change tracking is enabled?
Jan 29 '10 at 03:50 PM
Yes, look for the relevant row in sys.fulltext_indexes and ensure that crawl_end_date is after the time that the row was inserted, crawl_type is not 'P' and has_crawl_completed = 1
Jan 29 '10 at 06:00 PM
Matt Whitfield ♦♦
Thanks for your answer Matt, but that catalog view has information in the fields you've mentioned only about the initial full crawl. After the later changes made by DML statments in the table are propagated to the full-text catalog only the incremental_timestamp field is changing, although this might help me if I check it before and after the data modification.
You might want to raise it on connect then, because the last crawl after an update should be an incremental crawl, and should affect the end date just the same...
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Jan 29 '10 at 03:50 PM
Seen: 1578 times
Last Updated: Jan 29 '10 at 03:50 PM
Problem dropping full-text catalog
SQL Server 2005 FULL TEXT SEARCH
Full Text Search Optimization
Full text search in sql server 2005
How to use CONTAINS with inline queries in SQL2008?
Return the tokens matched in addition to the rows with a Full Text Search Query
Full-Text Search: the NEAR parameter and the WEIGHT parameter
Long Running Backup Job and SQL Server FullText Search…State “Change Pending”
Can I full-text search a temporary table?
Tuning full text indexes
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.