Thursday, August 16, 2012 7:01 PM
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 :
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
exec sp_configure 'transform noise words', 1
Friday, August 17, 2012 7:46 AM
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.
There are 10 type of people. Those who understand binary and those who do not.