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 ♦♦
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 29 '10 at 03:50 PM
Seen: 1983 times
Last Updated: Jan 29 '10 at 03:50 PM
Using Full-Text Search in SQL Server 2005 across multiple tables, columns
Full Text Search FreeTextTable Predicate Problem
Full Text Search not returning expected result
Why have phrase matches stopped working in my 2008 instance?
update more than one table using single querry
SQL Full Text Search
Cannot start msftesql service
Full text search using a table column as input criteria?
Long Running Backup Job and SQL Server FullText Search...State "Change Pending"