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 |
|
pat
Starting Member
1 Post |
 Posted - 2002-02-01 : 04:59:47
|
| when I query the database with full-text search and I enter such keywords as "a", "an" I get this error message:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a full-text operation failed. A clause of the query contained only ignored words. How can I filter out ignored words from the search? Is there a file where they are defined? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-01 : 12:48:26
|
| You can actually search for those words, if that is what you want, you would:- Stop the Microsoft Search service.- In the Windows explorer locate noise.enu file under\MSSQL7\FTDATA\SQLServer\Config\ directory.- Open it in Notepad. Locate the words you want to remove from 'noise wordslist' and delete them.- Save the file.- Start the Microsoft Search service.- Rebuild your full-text catalogNow your query should come up with results.If you want to just filter out those words, you would have to write a client side component that does that filtering.-Chad |
 |
|
|
|
|
|
full-text search ignored words