Refresh index of full text search

Posted by David on Stack Overflow See other posts from Stack Overflow or by David
Published on 2009-11-05T20:57:14Z Indexed on 2010/05/10 19:04 UTC
Read the original article Hit count: 230

Filed under:

Hi, in SQL Server 2008, when setting up a full text search, it gives me an option to choose a time/day for it to re-populate the index, can I do this from code instead like C# code? if so how would I do it? Would I need to execute SQL code from C# to refresh the index?

Also, say if I DONT re-populate the index and add some new records, by using the FTS query will the new records still come up? But slower? Or will they not come up at all unless i reindex?

© Stack Overflow or respective owner

Related posts about full-text-search