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  Transact-SQL (2005)  Ranking Lost in Fulltext search

Author  Topic  mr_evill Starting Member 1 Post Posted - 2008-08-24 : 08:51:31 HI Guy's I am trying to set up a very simple Freetext search my code is as follows. SELECT P.Name, P.Description, ct.Rank FROM FREETEXTTABLE(Products,(Name, Description),'Balloons Product') ct JOIN Products p ON P.ProductID = ct.[Key] ORDER BY Rank DESC The first time i run this query everything is fine the results are ranked in a descending order no problem at all. I then run the query again and all ranking is set to 0. After i rebuild the catalog everything works again but only once as before. PLEASE HELP !!!!!