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, 2010 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, 2010 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.
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, 2010 at 03:50 PM
Seen: 2365 times
Last Updated: Jan 29, 2010 at 03:50 PM
Add component to SQL 2005 SP3
Can't start SQL Server FullText Search
Customizing a FullTextSearch procedure to support paging?
Exclude file type from fulltext index
Sql Server 2008 Fulltext problem
How to resolve ss2008r2 errors 30064 and 17063?
String search looking for phone numbers
Significant difference between contains and containstable?
can i disable full text filter in production
Case sensitivity issue in FullText Searching?