Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
FreeText Search And Scheduling

Proposed FreeText Search And Scheduling

  • Thursday, May 17, 2012 7:41 PM
     
     
    Sign In to Vote
    0

    I am new to Sql FreeText Search..Sql Server 2008. I specified couple of columns for freetext, our users are updating those columns constantly (like product price etc). now my question is do I need to schedule the population of cataloge every hour or so? OR Sql will automatically grab the updates.

    the Reason why I ask this is because we are not able to search for new updated values for some reason. what is the best way to have FreeText in my case?

    Thanks

    www.SaqibKhan.Com

     

All Replies

  • Thursday, May 17, 2012 7:48 PM
     
     Proposed
    Sign In to Vote
    0

    SQL 2008 can do this automatically, this is an article  from Pinal Dave that may help.

    http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/

    Bill

    William F. Kinsley

    • Proposed As Answer by Papy Normand Friday, June 08, 2012 12:14 PM
    •  
     
  • Thursday, May 17, 2012 7:52 PM
     
     
    Sign In to Vote
    0
    this is exactally how I did it...could it be SQL Server Takes some time to update cataloge after updating the columns? my table has around 30K rows.

    www.SaqibKhan.Com

     
  • Friday, May 18, 2012 4:42 PM
     
     
    Sign In to Vote
    1

    Unlike the normal table indexes, there can be a delay with how long it takes to actually update the free-text index. Do the changes show up after a period of time or not at all? Have you verified that free text search service is running? Can you manually update the index and see the changes appear?

    Bill

    William F. Kinsley