[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