| Scott H 2002-11-29, 8:23 am |
| First, I've created a full-text catalog, selected my
tables, populated it, etc. The first problem I'm seeing is
my "Unique Word Count" shows only 1. That makes no sense
at all since I've got about 50 rows and the columns I
selected all full of data(ntext, varchar, nvarchar, etc.).
Does anyone know why it would only return "1" unique word
count???
Second issue I have is, when I run a SQL query on the
catalog it returns this error every single time:
Server: Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'MediaCatalog' for database ID
9, table ID 1797581442 with search condition '%naval%'
failed with unknown result (3447f958).
What does this error mean? Anyone know? I can run a simple
query against it and return the data I want, but when I
use "Contains" it send me this error.
Anyone's help would be greatly appreciated.
Thanks
|