Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Fulltext Search with contain

Author  Topic 

pushp82
Yak Posting Veteran

83 Posts

Posted - 2013-09-25 : 02:01:31
Hi,
I'm using full text search in sql server 2008 with contain keyword.
My issue is while I'm trying
select * from tbl_item_master where contains (ITM_FULLTEXT,'red and white')

above syntax gives me required output but while I'm trying

select * from tbl_item_master where contains (ITM_FULLTEXT,'red and the and white')

above syntax does not gives me output. I'm using system stop list and "the" is noise keyword.
I want to stop searching "the" but want result as per first syntax.
I do get warning " The full-text search condition contained noise word(s)."

Is it possible?
Please help!

pushp82
Yak Posting Veteran

83 Posts

Posted - 2013-09-25 : 08:16:01
It's done
I was missing.

sp_configure 'transform noise words', 1;
RECONFIGURE;
GO
Go to Top of Page
   

- Advertisement -