Post reply

full text indexing

  • March 13, 2006 at 8:25 am

    #103119

    I have two tables where I have full text search enabled and active. Table A is static- it doesnt change much. Table B is updated by users daily.

    Searches on Table B dont seem to include recent updates. Both table A and B were indexed using startfullindex one week ago.

    Is there a setting that updates the full text indexes immediately when data changes?

     

    Thanks,

    Rick

    Thanks,

    Rick Hodder

  • March 13, 2006 at 8:51 am

    #626276

    Please look up in BOL : Full-Text Indexing Support, sp_fulltext_catalog, sp_fulltext_table and other related entries. I don't think copying and pasting everything here would be of some use... just one little piece of it (but don't rely on it only, read the BOL for more detailed info):

    This example activates and starts propagating tracked changes to the full-text index as they occur.

    USE Northwind
GO
EXEC sp_fulltext_table Categories, 'Start_change_tracking'
EXEC sp_fulltext_table Categories, 'Start_background_updateindex'

  • March 13, 2006 at 9:40 am

    #626292

    Thanks!

    Thanks,

    Rick Hodder

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply