What is the differences between:
EXEC sp_fulltext_catalog 'Cat1', 'start_full'
EXEC sp_fulltext_table 'Table1','start_full'

if "Table1" is a full-text indexed in catalog "Cat1".
Do I need to execute both SP?

You only need to do one. If you start a full population on a catalog all
tables full text indexed in that catalog will be re-indexed. If you do it on
a table, only that table will be full text indexed again.

--
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



[quoted text, click to view]

Thanks


[quoted text, click to view]