sql server full text search: Hi

Help needed on Full text indexing multiple partitioned table

Let me explain u the actual scenario
I have a big Base Table that holds ntext columns(2columns) and other columns that are full text indexed to be used in FTS. This Base table grows every day with new data being inserted every day. As it is getting very difficult for me to FTS on such a large table, we decided that we would have to go in for partitioning the base table based on year. Based on that in the present scenario, the base table can be partitioned into 57 tables ( 1939 - 1996).
We've designed our search application in such a way that we would be querying only one table at a given moment most of the time. But the glitch is that there is an option for the user to query for data from all the years. which would require us to search from all the partitioned (57) tables. How do we query the Full text catalog for all these tables

if it is 2 - 3 tables i could use a solution like below posted on the microsoft newsgrou

use Northwin
g
SELECT e.LastName, e.FirstName, e.Title, e.Notes t.TerritoryI
from Employees AS e, EmployeeTerritories t
containstable(Employees, Notes, 'BA') as A
containstable(EmployeeTerritories, TerritoryID, 'Sales') as
wher
A.[KEY] = e.EmployeeID an
B.[KEY] = e.EmployeeI


but this solution is not feasible in my case when i have to use 57 tables.

I am curious to know IF there is any way that i can directly query the Full text catalog without specifying the table name so that it can return a result set, which also contains the table name corresponding the result queried for among others.

I would also be happy to hear from you of any other solution to my basic problem of FTS a very big table other than partition the base table

regards
Prudhv

I think you should have 57+1 tables. One table for each year, and then one
parent table for all years.

When the user wants to search all tables they would query the parent. A
single year they would query one of the children.

There is no way not to specify the table name in a FTS query.
[quoted text, click to view]
columns that are full text indexed to be used in FTS. This Base table grows
every day with new data being inserted every day. As it is getting very
difficult for me to FTS on such a large table, we decided that we would have
to go in for partitioning the base table based on year. Based on that in the
present scenario, the base table can be partitioned into 57 tables ( 1939 -
1996).
[quoted text, click to view]
querying only one table at a given moment most of the time. But the glitch
is that there is an option for the user to query for data from all the
years. which would require us to search from all the partitioned (57)
tables. How do we query the Full text catalog for all these tables.
[quoted text, click to view]
Full text catalog without specifying the table name so that it can return a
result set, which also contains the table name corresponding the result
queried for among others.
[quoted text, click to view]