Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tuppers
Starting Member
12 Posts |
 Posted - 2005-12-03 : 16:58:00
|
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.Can any one point me in the right direction?Thanks in advanceTuppers! |
|
|
Tuppers
Starting Member
12 Posts |
Posted - 2005-12-05 : 04:00:01
|
| hi figured it out! i hadnt created the primary key on the table to make the index on!! Silly me!!Thanks for looking!Tuppers!! |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 06:46:45
|
quote:
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.
The error clearly specified that 'ProductID' is not Primary Key  MadhivananFailing to plan is Planning to fail |
|
|
|
Tuppers
Starting Member
12 Posts |
Posted - 2005-12-05 : 12:55:01
|
| i get that now!! but lack of sleep does not help!! ney mind!! i was wondering if i had a join between two tables which both had indexes on can i use the following to search both tables:CONTAINS (*, 'sun')???Tuppers |
|
|
|
|
|
|
Full Text Searching