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.
asked Aug 07 '12 at 07:51 PM in Default
go to database-> storage-> Full text catalog--> rebuild the catalog
answered Aug 08 '12 at 10:09 AM