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.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Contains function of FTI does not return result.

Author  Topic  thirith Starting Member 3 Posts Posted - 2010-05-17 : 13:42:58 Hi all, I am facing problem with the Contains function that couldnot found the result. The problem that I found is that word in the NoiseWords list of SQL server. I tried few step as Book online mention as the following step: - delete word from NoiseWords list - Rebuilt Full-text Index But after rebuilt full-text Index finished. I still couldn't find the result. (I could found by using LIKE) did i miss any step? Thanks, Thirith.