hello to everyone ,
We have in our company a two nodes active-passive cluster with SQL Server
2000 SP4.
Recently one of our customer required from us to create a full text
catalog for some tables & columns
for his database.
So we made it ,but we realise that Microsoft Search didn't work when we
use a query in order to check it if it works fine.
The service was running and i tried several times a restart of the
service.
For example we made a full text catalog for the table "News" and the
column "newstuff" .
Then we run this query : SELECT newstuff FROM news
contains(prices,'suspeding')
and the answer was nothing ,not error ,not message ..just nothing.
If we run this instead : SELECT newstuff FROM news where newstuff like
'%suspen%'
we took as a result hundreds of lines and that is correct.
I found those links-workarounds :
http://support.microsoft.com/default.aspx?scid=KB;EN-US;263712
http://support.microsoft.com/kb/317746
http://www.citydesknews.com/FogBugz/kb/dbsetup/FullTextSearch.html
Also i post some of the logs recorded in the application log of the event
viewer :
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3024
Date: 26/8/2008
Time: 10:17:41 рм
User: N/A
Computer: SQL2
Description:
The crawl for project <SQLServer SQL0150100005> could not be started,
because no crawl seeds could be accessed. Fix the errors and try the crawl
again.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3035
Date: 26/8/2008
Time: 10:11:24 рм
User: N/A
Computer: SQL02
Description:
One or more warnings or errors for Gatherer project <SQLServer
SQL0150100005> were logged to file
<V:\SQLprog\MSSQL\FTData\SQLServer\GatherLogs\SQL0150100005.1.gthr>. If you
are interested in these messages, please, look at the file using the
gatherer log query object (gthrlog.vbs, log viewer web page).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I tried to made/check full text catalogs for other databases but the results
was the same..its a global problem.In another SQL server works fine.
Any ideas ???
thanks in advance.
Cipher.