2012年3月19日星期一

Full Text Issues

Hi i am really new to full text searching, I have created a catalog using:
sp_fulltext_catalog 'textcatalog','create'

and now i want to add a table with:
sp_fulltext_table 'Product', 'create','textcatalog', 'ProductID'

where product is a table in my database and productID is the primary key to that table. The primary key cannot be null,

But i get an error:
'ProductID' is not a valid index to enforce a full-text search key. You must specify a unique, non-nullable, single-column index.

I have a feeling i have to create some sort of index but am not sure how!

Can any one point me in the right direction? I am using SQL 2000

Thanks in advance

Tuppers!

i am wondering if when setting up the table i should of declared something? should i have done something like: CONSTRAINT [ProductID] PRIMARY KEY etc?

Tuppers|||

hi figured it out! i hadnt created the primary key on the table to make the index on!! Silly me!!

Thanks for looking!

Tuppers!!

|||

I indexed the primary key and the field for full-text search but still getting the same error message. Please help out. Thanks.

blumonde

没有评论:

发表评论