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 2000 Forums
 SQL Server Administration (2000)
 freetext returns no results

Author  Topic 

borquee
Starting Member

3 Posts

Posted - 2005-06-07 : 10:18:49
Hi,
Have a problem with freetext search. I did everything by the book but FREETEXT returns no results. Catalog property says "item count 0" (as it can't access any data on the server)

Thing works on my server in the office but it does not work at ISP's server

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-06-07 : 10:33:40
Maybe a stupid question but have you populated the catalog?
Do you have a last population date?

Beauty is in the eyes of the beerholder
Go to Top of Page

borquee
Starting Member

3 Posts

Posted - 2005-06-08 : 05:32:31
yes I did (and scheduled for full population every two days)
Go to Top of Page

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-06-08 : 06:01:41
So did it fall over when populating?
And what does "as it can't access any data on the server" mean?



Beauty is in the eyes of the beerholder
Go to Top of Page

borquee
Starting Member

3 Posts

Posted - 2005-06-08 : 07:07:11
I got all the standard messages (working and then idle). since the indexing and sql are two separate applications it looks like that the problem might be in permision to access... I have to explain to my ISP where to look for problems (they never got this problem before and neither did I)
Go to Top of Page
   

- Advertisement -