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
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