Full Text Search Error, with sp3 applied!

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 Development (2000)

Full Text Search Error, with sp3 applied!

Author

Topic

fizgig
Starting Member

34 Posts

Posted - 2002-02-05 : 04:50:13

OK people. I get this error:

Server: Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'tfSearch' for database ID 18, table ID 242099903 with search condition 'kitesurf' failed with unknown result (403df95c).

My creation script look like this :

EXEC sp_fulltext_catalog 'tfSearch', 'create'
EXEC sp_fulltext_table 'bericht', 'create', 'tfSearch', 'PK_bericht'
EXEC sp_fulltext_column 'bericht', 'tekst', 'add'
EXEC sp_fulltext_column 'bericht', 'onderwerp', 'add'
EXEC sp_fulltext_table 'bericht', 'activate'
EXEC sp_fulltext_catalog 'tfSearch', 'start_full'

Properties of the catalog:

item count : 2340
cat. size : 1 MB
unique key count : 19031

Server props:

Microsoft SQL Server 7.00 - 7.00.996 (Intel X86) May 23 2001 15:54:35 Copyright (c) 1988-1998 Microsoft Corporation Small Business Server Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
MSSEARCH service started

What can possibly be wrong?

chadmat
The Chadinator

1974 Posts

Posted - 2002-02-05 : 10:59:10

Did you install full text after applying SP3? Try reapplying SP3, then try the queries again.

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources