Full Text index creation fails.

I try to define a Full Text Index on a table in my db with Server Management Studio. Connect to the DiscountASP.net engine works fine.
Select table columns OK; Select Change Tracking = Automatic; Select Full Text Catalog = xxxx (i defined the FT Cat in the storage folder);
Define Population Schedules results in an Error. Even though this schedule is optional I cannot get beyond this point.
Any advice is appreciated on how to create a FT index.

-Eric

 

hi Junior,

This means that a query like this will not work ?

sp_fulltext_table 'Attraction', 'create', 'Catalog', 'id'

How can I do so to add a table in my catalog?

Thanks for any help

Post Edited (Le Ced) : 10/17/2006 9:09:44 PM GMT

 

Curiously, this query didn't work for me.

The only way I found was:

Create full text on table by GUI and catalog that was created in SQL 2005 Manager
Initialize in the table, each fields set to full text index and which language...

With sql manager 2000, no posssibilities, and with query, only enable full text on DB and catalog creation has worked.
After that, I was not able to use SQL 2000 Mgr to do something else.

However it is a SQL 2000 DB.

But now it works fine, with GUI !?

Le Ced

 

This is my bypass since I am not a SQL guru.
I uploaded my .mdf and .log files to the _database folder. These areSQL2005 files.
If you atach the .mdf toyour DiscountASP db with SQL Server Management Studio you will get the FT index settings as you have created locally.
In the storage folder right click FT Catalogs, select New FT Catalog. In the window enter name, click OK.

To be sure on Population, rightclick the table you want indexed, click FT Index, click Start full population. FT Index population reports Success.

As a new user to the service, and since this is the way it works locally, I assume my FT indexing plus automatic updateis working now.

Thanks for the comments. -Eric