I am working on SQL Express 2005 with advanced services which includes full text search. I am using Full-Text catalogs and indexes. Yesterday I created full text catalog and indexes and I was able to perform various full text search queries on the table which had full text index.
But the requirements changed and I had to remove the existing full-text index and catalogs, I recreated the catalog and index on a text column, but I am not getting any results for full-text queries even though they have the keywords for which i am making a full-text search. The query "SELECT fulltextcatalogproperty('catalogname', 'ItemCount');" shows 0 as it's output which means that the full text catalog and index are not getting populated.
Please help in case anyone know on how I can resolve this issue. I even tried using the following commands:
ALTER FULLTEXT INDEX ON START FULL POPULATION;
But it says that the full population is active. Your reply will be greatly appreciated.