|
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 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.
(comments are locked)
|
stopped working. It is not retuning any results, please see the attachment for index information on table and query below.
|
go to database-> storage-> Full text catalog--> rebuild the catalog Thanks Ramesh, Can i know the reason why we need to do like that. What happens when we are rebuilding the catalog. Harish kakani.
Aug 08 '12 at 01:51 PM
harishkakani
Full text Index will be rebuild
Aug 09 '12 at 05:28 AM
ramesh 1
@Harishkakani - if this has answered your question please click the tick/check up and to the left of the answer so that others can see what helped in this problem.
Aug 09 '12 at 09:29 AM
Fatherjack ♦♦
I would be very curious about rebuilding the whole catalog which may have many full text indexes. I pointed out some key things to troubleshoot it (in form of a comment) before moving in any direction. Knowing the root cause would definitely help you now and will also help in future. If your index is need to be rebuilt then it has to be done properly and I guess ALTER FULLTEXT INDEX is the command to use and Having said that I would still ask you to troubleshoot the matter and think of any recent change done which could be relevant. Then it would be easier for you to find the precise solution
Aug 09 '12 at 09:32 AM
Usman Butt
(comments are locked)
|
The key is to know your environment in detail. Some obvious questions come to mind are