full text search in sql server 2000

10 pts.
Tags:
full text search
SQL Server 2000
can anyone tell me how I can get full text search to work in SQL Server 2000 ? Ive installed it, created a catalogue, selected a table (with a primary key) stepped through the wizard, in fact followed all instructions to the letter. When I run this query

SELECT *
FROM guidance
WHERE CONTAINS(Title, 'Cardiac')


I get this error

Server: Msg 7342, Level 16, State 1, Line 1
Unexpected NULL value returned for column '[FULLTEXT:guidance].KEY' from the OLE DB provider 'Full-text Search Engine'. This column cannot be NULL.
OLE DB error trace [Non-interface error:  Unexpected NULL value returned for the column:  ProviderName='Full-text Search Engine', TableName='[FULLTEXT:guidance]', ColumnName='KEY'].


Ive Googled the error and followed the various suggestions, even renaimg the registry entry and reinstalling the full text functionality from the master disk. Nothing seems to work.

this query returns 1 which shows that its implemented

SELECT DATABASEPROPERTY('dbName','IsFulltextEnabled')


Ive run out of options.,...help !
ASKED: November 21, 2007  3:48 PM
UPDATED: October 14, 2013  7:43 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like you didn’t set the primary key correctly for the full text column. Right click on the catalog, select properties. There should be a tab with the table shown, as well as the columns which have been indexed. You should also be able to select which column is the primary key of the column. Make sure that the current primary key is listed as the primary key.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following