full text catalog empty

Hi,

I am trying to setup a full text catalog on one table in my database. Although the catalog is created fine and no erros are reported when creating or populating the catalog. It seems to be empty as its size is only 1Mb and my query:

select top 10* from kmuser.tbl_webpages
where contains (WebPageHTML_FT, '"aruba"'

returns no rows, while:

select * from kmuser.tbl_webpages
where webpagehtml_ft like '%aruba%'

returns 6 rows.

I have read several articles on the subject and have followed them to a T. I've deleted it and recreated so many times now both through Enterprise manager and through query analyser using the stored procedure sp_fulltext_catalog.

I've checked that full text catalog is enabled using:

select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')

I am really stuck. Does anyone have any ideas? Btw I am using SQL Server 2000 still

Many thanks

Is FulltextServices started, what do the logs of FullText Service tell you ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de