December 16, 2002 at 6:13 pm
Hello.
I'm trying to work around a Contains function that only has one Noise word as the search string. Any ideas? I'm running SQl Server 2000. The error message I get is:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed.
A clause of the query contained only ignored words.
Everett Wilson
ewilson10@yahoo.com
December 17, 2002 at 2:10 am
I don't know if others think this is a bad idea, but one option you potentially have is to remove the offending word from SQL's Ignored/Noice file, typically found in:
\\SERVERNAME\c$\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config\noise.eng.
The noise words are just contained in a text file format. A repopulation of your full text catelogues will be necessary (and maybe(?) a restart of your server).
December 17, 2002 at 10:45 am
Thanks for the reply.
My unit it actually worried about the entire list. Unless I come across a better way I'm planning on importing the list of noise words into a table and then modifying the Contains fuction to avoid noise words.
If anyone has a better idea, please let me know.
Thanks.
Everett Wilson
ewilson10@yahoo.com
December 18, 2002 at 1:51 am
You can just remove the whole file, hence have no noise words
Steven
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply