sp_fulltext_catalog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cenk FIRAT - 17 Oct 2006 10:14 GMT

In 1 database I have 2 cataolg files. how many times a day I must execute
sp_fulltext_catalog sp?
"Full" or "incremental" which type of arguments I must use? and how many
times ?(a day or a week)

Reply to this Message

Hilary Cotter - 17 Oct 2006 10:22 GMT

Use change tracking if possible. With change tracking it will automatically
keep up to date. Otherwise run an full population every time you wish your
catalog to reflect the current contents of your tables you are full-text
indexing. You need a time stamp column on your tables for an incremental
population to be run, otherwise a full population will be run. Incremental
populations are frequently as lengthy as full populations.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> In 1 database I have 2 cataolg files. how many times a day I must execute
> sp_fulltext_catalog sp?
> "Full" or "incremental" which type of arguments I must use? and how many
> times ?(a day or a week)

Reply to this Message