Filtering noise words in a free text search

[Hesham Amin]

Hi I use SQL Server 2000 + MS search service to add a text search capability to an application. I use CONTAINS keyword to search and the problem that SQL server raises an error (Execution of a full-text operation failed. A clause of the query contained only ignored words.) When the words entered by user contain noise words like (And-or-also-an-another). How to make the engine ignores the noise words? OR: How to get a complete list of keywords and noise words at runtime to filter them? Notes: -noise.dat file does not contain all the invalid characters. -I can't use FREETEXT instead of CONTAINS because It gets awful result with Arabic language (the major language used in the project) any comments / suggestions are appreciated and welcomed.