Rebuilding Full Text Catalog -- sql server full text search

Dino Buljubasic
8/11/2005 7:24:15 PM

Hi,

I have created a db install app that will install all datatables,
build full-text catalogs and add job scheduler to populate the
catalogs several times a day.

However, I would also like my catalogs to be rebuilt every midnight
and repopulated again. I know of Rebuild method and Start method but
how do I schedule it so it is rebuilt every midnight?

Thank you,

Hilary Cotter
8/11/2005 9:31:28 PM

Why do you want to do a rebuild? A full population should suffice.

To schedule a rebuild you would schedule sp_fulltext_catalog
'catalogname','rebuild'

Have this job run in the database you are full-text indexing.

--
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
[quoted text, click to view]

sql server full text search : Rebuilding Full Text Catalog