Full-Text index automatic change tracking

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?

more ▼

asked Jan 29, 2010 at 03:50 PM in Default

avatar image

102 1 3 5

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Jan 29, 2010 at 06:00 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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.

Jan 30, 2010 at 01:50 PM dillinzser

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...

Jan 30, 2010 at 04:08 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 29, 2010 at 03:50 PM

Seen: 2850 times

Last Updated: Jan 29, 2010 at 03:50 PM

Copyright 2018 Redgate Software. Privacy Policy