I support an application that uses full text indexes in SQL Server 2000.  I'm
trying to resolve an issue where by the results of a search in the production
application do not include the expected results.  I've been unable to
reproduce the scenario in my development environment.

Both the production and development environments are running the following
version of SQL Server.

Microsoft SQL Server  2000 - 8.00.2040 (Intel X86)
    May 13 2005 18:33:17
    Copyright (c) 1988-2003 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

The queries and results from the production environment are below.  The
first query returns no results.  However, the second query (which excludes
"M*"' from the search criteria) includes the expected results.  In my
development environment both queries return the expected results.  I've
verified that the noise word files match in both environments, and I've had
the full text index in the production environment deleted and rebuilt twice.

I don't know what else to check / try.  Thanks for any help that can be
provided.

SELECT H.HoldEntityID, H.EntityName
FROM dbDatabase.dbo.tblLSHoldEntity H
    INNER JOIN CONTAINSTABLE (
        dbDatabase.dbo.tblLSHoldEntity, EntityName,
        '"Knudsvig*" AND "Ronnie*" AND "M*"', 250) FT
        ON H.HoldEntityID = FT.[KEY]
/* RESULTS
HoldEntityID EntityName                                                      
                                                                             
       
------------ --------------------------------------------
(0 row(s) affected)
*/

SELECT H.HoldEntityID, H.EntityName
FROM dbDatabase.dbo.tblLSHoldEntity H
    INNER JOIN CONTAINSTABLE (
        dbDatabase.dbo.tblLSHoldEntity, EntityName,
        '"Knudsvig*" AND "Ronnie*" ', 250) FT
        ON H.HoldEntityID = FT.[KEY]
/* RESULTS
HoldEntityID EntityName                                                      
                                                                             
       
------------ --------------------------------------------
891260       RONNIE M KNUDSVIG; FORREST J EAST
1132654      RONNIE M KNUDSVIG; CATHERINE A KNUDSVIG
(2 row(s) affected)
*/