Hi,

Typical SSMS!

There are two ways to create FT indexes.

1) Through Storage\Full Text Catalogs\'Catname'\Properties under the Tables/Views.

2) By right clicking on the table, then Full-Text index\Define Full-Text Index...

The first...

Hi,

Did it through SSMS...

Created new FTC with totally new name.

Removed the tables from the old FTC

Set the tables/columns up in new FTC

Tested 'contains' queries were working again.

Waited for the population...

The queries use are below but all they do is list the entries for the current DB. The first gives all data, the second formats the data to go into...

Hi,

Thanks for the prompt reply.

sys.database_files also lists the old FTC and size info and no mention of the new one.

If I use SSMS and look at storage under DB properties...