[thelist] populating full-text catalogs more often than daily?

[Chris Blessing]

It appears to be that I didn't do enough research.  Books Online for SQL
Server revealed this stored proc:

sp_fulltext_catalog <catalog>, 'start_incremental'

Pretty shweet ;)

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Chris Blessing
> Sent: Wednesday, January 16, 2002 2:05 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] populating full-text catalogs more often than daily?
>
>
> 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
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !