Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL full text catalog problem

 
   Database Help (Home) -> Full Text RSS
Next:  using rank in fulltext  
Author Message
Cipher

External


Since: Sep 01, 2008
Posts: 1



(Msg. 1) Posted: Mon Sep 01, 2008 12:59 pm
Post subject: SQL full text catalog problem
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

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.

 >> Stay informed about: SQL full text catalog problem 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Full Text Catalog Scripting - When rebuilding a replication set it seems that the target db loses its full-text catalog. Is there a way to script the addition of the full--tect catalog to the target db? Thanks.

Unable to "enable" full text catalog creation - please hel.. - Hi, Hope u can help me with this one. I'm running SQL Server 2000. I try to build a full text catalog by running: sp_fulltext_catalog 'Cat_Desc', 'create' but I get the following error message: Server: Msg 15601, Level 16, State 1, Procedure..

FULL TEXT SEARCH PROBLEM - I have a table which has a record T17.1.516.32 I try SELECT Urun_Ad as guUrun_Ad FROM TBL_URUNLER WHERE ( (CONTAINS(Urun_Ad, '"*t17.1.516.32*"' ) )) it returns T17.1.516.32 i try SELECT Urun_Ad as guUrun_Ad FROM TBL_URUNLER WHERE (..

full text search problem!!.....help - hello my full text queries have suddenly stop functioning,when I press execute tab, its keep on saying "Executing query" for hours.Can any one tell me how to resolve this problem. I am using SQL server 2005.In the enterprise manager, I can see ...

urgent help needed: error 7342 (full text search problem) - I would be very grateful for advice or suggestions for the following problem. I have had no problem with Full Text Search in SQL2000 on my PC under XP Pro using the Developers Version of SQL 2000. However, I have created another copy of the same..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]