full text search in 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 variouis suggetions, 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 implementd
SELECT DATABASEPROPERTY('dbName','IsFulltextEnabled')
Ive run out of options.,...help !
Software/Hardware used:
Software/Hardware used:
ASKED:
November 21, 2007 3:48 PM
UPDATED:
January 29, 2008 1:31 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
