Full Text Search on Clustered SQL Server 2000

[Claire Duncan]

I am using SQL Server Enterprise 2000 and have created a full text search on the pubs database as per the instructions below:-

http://www.databasejournal.com/featu...le.php/3441981

However, when I verify the search :-

SELECT title, notes
FROM titles
WHERE CONTAINS (notes, ' "quick easy" ')

no rows are returned.

In the full text tab under the pubs database, my demo catalog is listed, but the Item count and unique key count are both 1. There are 18 records in my titles table.

The full text files location is on my H drive which is set up as a dependency of SQL Server in cluster admin.

In SQL EM->Support Services->Full Text Search->properties, the location of my temporary files was set to C:\winnt\temp\gthrsvc. As nothing in cluster admin can see this directory, I changed it to H:\temp but still no data is returned by the query. There is no default error log file listed and I can't work out how to change this.

I have checked the Search service is running under the local system account.

I can't find any error messages which may indicate a problem apart from the fact that the T-SQL query doesn't return any data.

Anyone any ideas? Any help is much appreciated.

Thanks in anticipation.

Claire

[ravinder_k]

can you try this step again...

11. Right click and select "Start Full Population."

[Claire Duncan]

Fixed it! This is the solution:-

http://support.microsoft.com/default...b;en-us;817301

Then re-populate.

Fantastic.

[rmiao]

You can set schedule to re-populate it.