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
 .NET Inside SQL Server (2005)
 Full-Text Catalog Problem

Author  Topic 

el_omer
Starting Member

2 Posts

Posted - 2007-10-30 : 10:30:47
Hello Everybody,

I have a really strange problem and i need your advice...

in one line:
creating full-text index bring to Rank = 0 when running FreeTextTable (although it shouldn't be).

in details:
when creating a new catalog on defining full-text index process, I finish the process successfully and then run a query (FreeTextTable) on the first time i get rank = 731, and after that get always rank=0. after checking every option in this process, try to use old catalog (belongs to different full-text search) it works perfectly.

does anyone has a clue?

thanks in advance,
Omer

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-30 : 23:17:43
Did you populate the catalog after creating it?
Go to Top of Page

el_omer
Starting Member

2 Posts

Posted - 2007-10-31 : 04:58:20
Thanks that was it,
From some reason the catalog was not fully populated although i set it to be automatically updated.

Thanks again,
Go to Top of Page
   

- Advertisement -