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.
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 doneI was missing.sp_configure 'transform noise words', 1;RECONFIGURE;GO |
|
|
|
|
|