create store procedure to incremental populate full text index tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eslim - 16 Nov 2005 21:01 GMT

I need to create a store procedure to perform incremental population of full
text index table. The store procedure will be call from my program.

Any ideas ???

Signature

xxx

Reply to this Message

Hilary Cotter - 16 Nov 2005 21:51 GMT

This is probably what you want.

exec sp_fulltext_table N'[dbo].[authors]', N'start_incremental'

I suggest you have a look at change tracking and schedule the index updates.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I need to create a store procedure to perform incremental population of
>full
> text index table. The store procedure will be call from my program.
>
> Any ideas ???

Reply to this Message

eslim - 17 Nov 2005 13:35 GMT

Thanks for u answer.

How to create store procedure to perform full population of full text index
table?

Signature

xxx

> This is probably what you want.
>
[quoted text clipped - 7 lines]
> >
> > Any ideas ???

Reply to this Message

Hilary Cotter - 17 Nov 2005 15:00 GMT

You should be able to use sp_fulltext_table for this.

Please clarify what you are trying to do.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Thanks for u answer.
>
[quoted text clipped - 14 lines]
>> >
>> > Any ideas ???

Reply to this Message