Is there a way to get informed when SQL Server updates a full text index

Asked Apr 14 '16 at 21:32

Active Apr 15 '16 at 04:53

Viewed 36 times

I have a full text index on my SQL Server table with option CHANGE_TRACKING AUTO.

I can access the keywords and document IDs using the convenient sys.dm_fts_index_keywords_by_document system view.

My question is that can I get informed when a keyword is added or a new document is associated with an existing keyword ?

I tried to create an after insert trigger on sys.dm_fts_index_keywords_by_document but - not surprisingly - it is not allowed.

Regards,

edited Apr 15 '16 at 04:53

marc_s

asked Apr 14 '16 at 21:32

Samet Sevilen

you'd better to ask on DBA site: http://dba.stackexchange.com – FLICKER Apr 14 '16 at 22:26
Which SQL Server version are you on? – TToni Jun 22 '16 at 15:14

0 Answers0