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!
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
没有评论:
发表评论