No hit, free-text search on filestream

Question

I am doing a FTS on filestream enables tables. When i do a simple search withit works fine and returns two rows with 'how'

Select name,CAST([file_stream] AS varchar) from [dbo].[FileTableTb] where CAST([file_stream] AS VARCHAR) like '%how%'

But when i do a FTS query like :

SELECT Name
FROM dbo.FileTableTb
  where  freetext([file_stream] , '"how"')

It returns NO results but just

Informational: The full-text search condition contained noise word(s).

I have already suppress noise words using :

exec sp_configure 'show advanced options', 1
RECONFIGURE
GO
exec sp_configure 'transform noise words', 1
RECONFIGURE
GO

any ideas/help?

thanks

VK

---

vandana

Answer 1

hi,

Until your FT index is being built, your FT search may not return any result. It takes a while until the word breaker, etc. build your index. Make sure that your FT index is built already.

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me