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.
| Author |
Topic |
|
goblyn27
Starting Member
39 Posts |
 Posted - 2001-12-19 : 16:41:09
|
| Hello, I Seem to be missing something crucial in setting up a full text catalog on one of my companies SQL servers. The server (MSSQL7.0) already has full text indexing service and a different database on the server is currently using it seucessfuly to perform search against their DB. I set up a catalog for my DB using EM on the server itself, using the supplied wizard. It sucessfully created the index. Then I went to the index itself, selected populate index, and after a little bit (its not a very big database yet) the properties show 450 items, 1MB size. In the query analyzer I try to run the following query: select Body from tblPressreleases WHERE CONTAINS(body, 'keyboard') And I get the following error: Search on full-text catalog 'apRoland1' for database ID 13, table ID 78623323 with search condition 'keyboard' failed with unknown result (2cbcf958). I am totally at a loss here and more than open to any suggestions? Is there something that needs to be done after creating and populating the index? Or perhaps there are some angry vengeful gods that require a sacrifice? Anything would be helpful."DuuuDe!! I suck!" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-20 : 16:30:26
|
| Have you recently applied SP3? You may want to try reapplying it.-Chad |
 |
|
|
goblyn27
Starting Member
39 Posts |
Posted - 2001-12-21 : 15:08:51
|
| nothing has been applied recently, plus the other databse on the server is still able to perform their full text searches"DuuuDe!! I suck!" |
|
|
|
|
|
|
Full Text Search Errors