Author |
Topic |
quarinteen
Starting Member
40 Posts |
Posted - 2007-10-15 : 12:42:01
|
i am tring to create the full text catalog I am following the direction at http://technet.microsoft.com/en-us/library/ms189520.aspx but on the last command it gives me an error'PK_problem' is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, and has maximum size of 900 bytes. Choose another index for the full-text key.also I tried the wizard in the managment express but it does not have a option when I right click on the table for Full-Text Indexwhat am I doing wrong??? |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-15 : 13:12:15
|
"on the last command it gives me an error"What's the error message?If you are doing this by script can you post the script here for us to look at pleaseKrsiten |
 |
|
quarinteen
Starting Member
40 Posts |
Posted - 2007-10-15 : 14:13:01
|
Column 'problemBody' in table 'support' is of a type that is invalid for use as a key column in an index. |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-15 : 14:55:35
|
I suspect it is either Text or Bit.Neither of those are valid in an index. At least I think you cannot use a Bit datatype in an index.Kristen |
 |
|
quarinteen
Starting Member
40 Posts |
Posted - 2007-10-15 : 16:03:45
|
Maybe I just dont understand how this works. I need to have the column problembody to be searchable with full keywords (and yes it is a Text) So if I create a colunm just for that what does it need to be and can I still do full text searches on the problem Body column?The database I have has one column it is going to be a knowledge base I have 1 table and 7 columnsproblemId varchar50 primary key not nullproblemTitle varchar50 not nullproblemBody text not nulllinkOne varchar 50linktwo varchar 50link3 varchar50linkfour varchari want to create a asp searchpage with a search box and I want to be able to search like a google search page. |
 |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-15 : 22:31:40
|
Tried problemTitle column for full-text search key? |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-15 : 23:05:53
|
Hopefully I've understood your confusion:You need to provide two things:1. Text column for the Free Text tools to index, and your users to be able to search2. A single-key, unique, indexed column that references the record. Your PK [problemId] will do just fine for thatKristen |
 |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-15 : 23:28:21
|
I think the issue is that you need proper index key in the table to create full text catalog. |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-15 : 23:47:20
|
Won't the PK do for that rmiao? |
 |
|
quarinteen
Starting Member
40 Posts |
Posted - 2007-10-22 : 09:25:26
|
This has been resolved |
 |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 22:25:35
|
>> Won't the PK do for that rmiao?A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, and has maximum size of 900 bytes. But PK can have multiple columns. |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-23 : 02:57:13
|
Ah, OK. I was referring to the table DDL the OP posted which hadproblemId varchar50 primary key not nullwhich seemed to be a single-part PKKristen |
 |
|
|