I did speak to Microsoft yesterday afternoon and they also
suggested reinstalling sp4-although they did not admit to
a bug. The kb only refers to the prob in SQL2000! I will
do so today.
>Good afternoon, JM,
>This is a bug with SQL Server 7.0 and I've seen this
resolved via either
>applying or re-applying the latest Service Pack. Yes, you
can re-apply SP4,
>assuming that you do not have a post-SP4 hotfix. Note,
the data in the
>'unknown result' (30dbf970) is garbage data and is not
>meaningful. Re-apply SP4 (be sure you're logged on as
Admin or as a member
>of the server's Admin group) and if that doesn't resolve
this error, I'd
>recommend opening a support case with Microsoft PSS SQL
>> Morning all,
>> I am using full-text search on our SQL Server 7 (sp4)
>> the first time. I installed the service, created a
>> catalog and index and populated the index. All went
>> well. The service is running, objects are enabled, and
>> issued this query,
>> SELECT cust_notes
>> FROM notescustlog
>> WHERE CONTAINS (cust_notes, ' late ')
>> I get the following error:
>> Server: Msg 7607, Level 17, State 1, Line 1
>> Search on full-text catalog 'Cat 1' for database ID 8,
>> table ID 610101214 with search condition ' late ' failed
>> with unknown result (30dbf970).
>> The closest thing I can find on the KB is Q317486 but
>> is for SQL 2000 and deals with very long CONTAINS
>> I don't think that is my problem!
>> Has anyone encountered this problem?
>> Thanks for any help.