Newbie question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 29 Nov 2004 17:09 GMT

Hi,
Can one Full-Text Catalog apply to more than one tables???
e.g. I need Full-Text Catalog in Northwind that needs to apply to
Customers and Categories table, should I create one Catalog for two tables or
one catelog for each table?
what is the difference???
Thanks a lot
Ed

Reply to this Message

John Kane - 29 Nov 2004 17:26 GMT

Hi Ed,
Yes, a FT Catalog can have more than one table in it, but the reverse (one
table in more than one FT Catalog) is not true.
For the Northwind example, you can do either, but for a better explanation
on the issues see, the last paragraph in the SQL Server 2000 BOL title
"Full-text Search Recommendations".

Regards,
John

> Hi,
> Can one Full-Text Catalog apply to more than one tables???
[quoted text clipped - 4 lines]
> Thanks a lot
> Ed

Reply to this Message