|
Home > Archive > SQL Server Full-Text Search > January 2006 > failed with unknown result
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
failed with unknown result
|
|
|
| Hi,
When I run the exemple from the BOL:
USE AdventureWorks;
GO
SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description
, 'ISABOUT (performance weight (.8),
comfortable weight (.4), smooth weight (.2) )' );
GO
I receive the error message
Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'AdvWksDocFTCat' for database ID 6, table or indexed view ID 1781581385 with search condition 'ISABOUT (performance weight (.8),
comfortable weight (.4), smooth weight (.2) )' failed with unknown result (0x80020005).
Does someone know why this error is throw?
Laurent
| |
| Hilary Cotter 2006-01-06, 1:23 pm |
| This works for me. Can you do any other SQL FTS searches on this server or
database?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lolo" <laurent.banon@soorce.fr> wrote in message
news:OxO1qTtEGHA.524@TK2MSFTNGP09.phx.gbl...
Hi,
When I run the exemple from the BOL:
USE AdventureWorks;
GO
SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description
, 'ISABOUT (performance weight (.8),
comfortable weight (.4), smooth weight (.2) )' );
GO
I receive the error message
Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'AdvWksDocFTCat' for database ID 6, table or
indexed view ID 1781581385 with search condition 'ISABOUT (performance
weight (.8),
comfortable weight (.4), smooth weight (.2) )' failed with unknown result
(0x80020005).
Does someone know why this error is throw?
Laurent
| |
|
| Yes I can but not this query with ISABOUT
"Hilary Cotter" <hilary.cotter@gmail.com> a écrit dans le message de news:
%23W4TlfuEGHA.1028@TK2MSFTNGP11.phx.gbl...
> This works for me. Can you do any other SQL FTS searches on this server or
> database?
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Lolo" <laurent.banon@soorce.fr> wrote in message
> news:OxO1qTtEGHA.524@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> When I run the exemple from the BOL:
> USE AdventureWorks;
>
> GO
>
> SELECT Description
>
> FROM Production.ProductDescription
>
> WHERE CONTAINS(Description
, 'ISABOUT (performance weight (.8),
>
> comfortable weight (.4), smooth weight (.2) )' );
>
> GO
>
> I receive the error message
>
> Msg 7607, Level 17, State 1, Line 1
>
> Search on full-text catalog 'AdvWksDocFTCat' for database ID 6, table or
> indexed view ID 1781581385 with search condition 'ISABOUT (performance
> weight (.8),
>
> comfortable weight (.4), smooth weight (.2) )' failed with unknown result
> (0x80020005).
>
> Does someone know why this error is throw?
>
> Laurent
>
>
| |
|
| Hi,
This work fine if I write the query
USE AdventureWorks;
GO
SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description
, 'ISABOUT (performance :0.8,comfortable :0.4, smooth :0.2 )' );
GO
"Lolo" <laurent.banon@soorce.fr> a écrit dans le message de news: OxO1qTtEGHA.524@TK2MSFTNGP09.phx.gbl...
Hi,
When I run the exemple from the BOL:
USE AdventureWorks;
GO
SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description
, 'ISABOUT (performance weight (.8),
comfortable weight (.4), smooth weight (.2) )' );
GO
I receive the error message
Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'AdvWksDocFTCat' for database ID 6, table or indexed view ID 1781581385 with search condition 'ISABOUT (performance weight (.8),
comfortable weight (.4), smooth weight (.2) )' failed with unknown result (0x80020005).
Does someone know why this error is throw?
Laurent
|
|
|
|
|