if you are using SQL 7, add a timestamp column to your
table and then use incremental populations. Schedule the
incremental population to run hourly or so.
If you are using SQL 2000 you can use change tracking with
update index in background.
[quoted text, click to view] >-----Original Message-----
>I have a database that has one column that I've given
full-
>text indexing so that I can do searches and what not.
>
>The only problem is that every time data is added to the
>index, it doesn't automatically become fully indexed and
>consequently can't be fixed.
>
>I know i'm doing something wrong, but am clueless as to
>what. . .
>
>Thanks a bundle,
>kelly
>.