[thelist] populating full-text catalogs more often than daily?
Chris Blessing
webguy at mail.rit.edu
Wed Jan 16 13:01:17 CST 2002
Hi all-
I have a full-text catalog that is currently being populated on a daily
basis per the schedule I setup for it within SQL Server 7. My problem is
that I have users who are adding content to the table being full-text
indexed, but that content isn't showing up in any searches until the
scheduler incrementally repopulates the catalog at 3am every morning. =)
So what I want to do is have the catalog repopulated everytime the content
column in the table that's full-text indexed is updated or when content is
inserted. If there's someway to do this incrementally with a sql or t-sql
command that would rock, but I can't seem to locate anything. Everyone
seems to be just peachy with a daily update! Surely someone has been in
this same situation needing a more immediate population schedule.
Any ideas? Muchos gracias.
Chris Blessing
webguy at mail.rit.edu
http://www.330i.net
More information about the thelist
mailing list