Hi,

I have the problem that if I search for certain phrases in SQL 2005 such
as "voice over", it returns no results.

I am using the following syntax:

declare @criteria varchar(100)
select    @Criteria = N'("voice*") AND ("over*")'

SELECT CategoryID, category, keywords
FROM tblCategory
WHERE CONTAINS(tblCategory.*, @Criteria)

In SQL 2000, I fixed this by following Hillary Cotter's advice and
removed the word "over" (and others) from the noise.eng file.

However now that I'm using SQL 2005, this doesn't seem to work.

I've edited both noise.eng and noise.enu, restarted the MS Search
service AND rerun the full text population and it's still not finding
the categories which contain the phrase "voice over".

Do things work differently in SQL Server 2005 or have I missed a step?

Thanks,

Nick...