Tuesday, August 07, 2012 8:01 PM
I created full-text search on table in which I am storing some text information like skills of employees (I.e. sq. server, .Net and Mainframes), it was working fine previously, but the same query stopped working. It is not retuning any results, please see the attachment for index information on table and query below.
select * from tbl_Jobs Where Contains(Skills_Keywords,'.Net')
Please find the database server information below.
Microsoft SQL Server Management Studio 10.50.1617.0 Microsoft Analysis Services Client Tools 10.50.1617.0 Microsoft Data Access Components (MDAC) 6.0.6002.18005 Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 8.0.6001.19272 Microsoft .NET Framework 2.0.50727.4223 Operating System 6.0.6002
Regards Harish Kakani.
Wednesday, August 08, 2012 6:27 AM
Hello Harish Kakani,
Please check if the full text catalog is populates. You can look it up in the properties of the FT catalog and with this query:
SELECT * from sys.dm_fts_index_keywords(DB_ID(), object_id('tbl_jobs')) AS FIK
Thursday, August 09, 2012 1:51 PM
Thanks for the reply, since for the first time I am working on Full text index. I followed below process suggested by one of my friend; it gave solution to my problem.
go to database-> storage-> Full text catalog--> rebuild the catalog
My knowledge in full text index is. I know creation and implementation process of full text index. I am very curious to know the root cause for the problem which I mentioned above.
Thursday, August 09, 2012 2:44 PM
When you create a FT catalog you can start the population manually.
For maintenance you can schedule the population, see Full-Text Catalog Properties (Population Schedule Page)
- Marked As Answer by Iric WenModerator Wednesday, August 15, 2012 9:45 AM