full text - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

full text

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources