x

Full-Text Programmatic Query not returning results - SQL Server

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 alt textstopped 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.

more ▼

asked Aug 07, 2012 at 07:51 PM in Default

harishkakani gravatar image

harishkakani
20 1 1 1

The key is to know your environment in detail. Some obvious questions come to mind are

  • Does the data really exists with .NET keyword now?
  • Is the index tracking changes automatically?
  • If tracking manually then does the scheduled OR manual process of index population ran?
  • Any change in the stop list words
Aug 08, 2012 at 06:20 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
go to database-> storage-> Full text catalog--> rebuild the catalog
more ▼

answered Aug 08, 2012 at 10:09 AM

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

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, 2012 at 01:51 PM harishkakani
Full text Index will be rebuild
Aug 09, 2012 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, 2012 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 START {FULL|INCREMENTAL|UPDATE} POPULATION is the option

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, 2012 at 09:32 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x586

asked: Aug 07, 2012 at 07:51 PM

Seen: 961 times

Last Updated: Aug 10, 2012 at 05:16 AM