Full-Text Programmatic Query not returning any results - SQL Server

Question

Hello There,

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.

---

Harish kakani

Answer 1

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

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hello Olaf,

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.

---

Harish kakani

Answer 3

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)

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing