remove ignored words - full text catalog

hey
when i try to search an "noise word" it drop me an ERROR
what i have done :
- stop full text service
- remove the words i want ,from noise.enu , noise.eng , noise.dat (@.@.language = u.s...) the files is in system32 and in program files\...\config .
- start full text service
-rebuild and after that re populate the catalog

and it still drop me an ERROR !!! how can i resolve this prob ?

tnx tnx .

Why are you storing SQL Server Full Text file in System 32, you don't create the part SQL Server creates the part. You just create the Text and NText datatype and upload the file SQL Server creates an Arithmetic pointer to the file and I know it cannot be in System 32. System 32 is in Windows folder SQL Server will not get a file from Windows folder. Run a search for Full Text, Microsoft Search Service, Micorsoft Catalog and CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE in SQL Server BOL(books online). Hope this helps.|||

no , i don't store the catalog in system 32 , the noise.* files are in library system32 and in ...\config .
when u install sql server , it copy the noise.* files to those librarys .
and correct , i use CONTAINS , i doesn't allways get this error , only when i search "ignored word"

|||

Try this ' "ignored word" ' or ' "ignored Wor*" ' it may make a difference. Hope this helps.

|||hye
sooo it doesn't give me an error ,BUT it doesn't give the "correct" answer exp' :
the phrase : "windows cd"
----------------
the search phrase : "cd"
it return "windows cd" <-CORRECT
----------------
----------------
the search phrase : "*c*"
it return "windows cd" <-NOT CORRECT
----------------
i dont need to search in part of the word .
so how can i search "c" that won't give me "ignored words" error & will search like all other words (that won't search part of the word , like the exm')
tnx a_r .
|||There are noise words try this link for better queries and more about noise words. Hope this helps.
http://www.databasejournal.com/features/mssql/article.php/3454281|||tnx .
but how can i remove those "noise words" ? that it won't give me the error .|||You did not read the aritcle it shows you how to edit that file. Hope this helps.|||hey , i read the article & and i did more that what the article intracte to do . see the first post .

Remove from noise list

how I can remove "c" from my noise word and how I rebuilt my catalog
to search on c#, c+, and c.
For SQL 2000 go to c:\Program Files\Microsoft SQL Server\MSSQL\Ftdata or
c:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Ftdata
For SQL 2005 go to
c:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Ftdata
Where X is your instance ID.
Edit the noise word list for your language, stop MSSearch (MSFTESQL in SQL
2005) save your changes and restart MSSearch or MSFTESQL.
Now you will be able to search on C#, C++ correctly, but no c++, or c#. It
must be uppercase in your content and queries to work.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cenk FIRAT" <CenkFIRAT@.discussions.microsoft.com> wrote in message
news:4357CA5D-6A74-4161-B3E4-A007268B6DDA@.microsoft.com...
> how I can remove "c" from my noise word and how I rebuilt my catalog
> to search on c#, c+, and c.
>