| 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 Index
what 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 please
Krsiten
|
 |
|
|
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 columns
problemId varchar50 primary key not null
problemTitle varchar50 not null
problemBody text not null
linkOne varchar 50
linktwo varchar 50
link3 varchar50
linkfour varchar
i 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 search
2. A single-key, unique, indexed column that references the record. Your PK [problemId] will do just fine for that
Kristen |
|
|
|
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 had
problemId varchar50 primary key not null
which seemed to be a single-part PK
Kristen |
|
|
|
|
full text