SharePoint / ASP.Net Development
Experiences from the field...
Navigation
   RSS 2.0
Categories
Entries by Month

# Tuesday, September 14, 2004

Joel Spolsky mentioned that he is using the full-text search feature of SQL Server and that it required a manual job to re-index the database.

In fact, SQL Server 2000 will monitor a table for changes to a table that is included in a full-text index. The sp_fulltext_table procedure has parameters to 'Start_change_tracking' and 'Start_background_updateindex'.

As I wrote in Joel's discussion board, I have a script I could share that enumerates all indexes on a server and sets the change tracking for all tables in the index.

Tuesday, September 14, 2004 2:45:07 PM (Central Daylight Time, UTC-05:00)  #    Comments [1]  | 
Friday, December 31, 2004 1:59:57 AM (Central Standard Time, UTC-06:00)
Hi,
I checked Joel's website (via Google & the site parameter) and found the quote (http://www.joelonsoftware.com/items/2004/09/14.html) and you are correct. However, Change Tracking with Update Index in Background is new with SQL Server 2000 and perhaps Joel's software must also support SQL Server 7.0.

However, I'd be most interesting in getting a copy of your SQL script for changing all FT Indexes from Incremental to CT with UIiB. Note, that when you change the setting an automatic Full or Incremental (depending upon the presence of a timestamp column) is executed. You can email me at jt-kane at comcast dot net
Thanks,
John
PS: I plan to blog on this at my MSN Spaces blog too!
Comments are closed.
Search

Further Reading...

Powered by: newtelligence dasBlog 2.2.8279.16125

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2008, Paul Schaeflein

Send mail to the author(s) E-mail