failed with unknown result

failed with unknown result

Post by Lolo » Sun, 08 Jan 2006 00:20:30


This is a multi-part message in MIME format.


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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>When I run the exemple from the BOL:</DIV>
<DIV><FONT color=#0000ff size=2>
<P>USE</FONT><FONT size=2> AdventureWorks</FONT><FONT color=#808080
size=2>;</FONT></P>
<P><FONT size=2>GO</P></FONT><FONT color=#0000ff size=2>
<P>SELECT</FONT><FONT size=2> Description</P></FONT><FONT color=#0000ff size=2>
<P>FROM</FONT><FONT size=2> Production</FONT><FONT color=#808080
size=2>.</FONT><FONT size=2>ProductDescription</P></FONT><FONT color=#0000ff
size=2>
<P>WHERE</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>CONTAINS</FONT><FONT color=#808080 size=2>(</FONT><FONT
size=2>Description</FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>
</FONT><FONT color=#ff0000 size=2>'ISABOUT (performance weight (.8), </P>
<P>comfortable weight (.4), smooth weight (.2) )'</FONT><FONT size=2>
</FONT><FONT color=#808080 size=2>);</P></FONT><FONT size=2>
<P>GO</P>
<P>I receive the error message <FONT size=1></P>
<P>Msg 7607, Level 17, State 1, Line 1</P>
<P>Search on full-text catalog 'AdvWksDocFTCat' for database ID 6, table or
indexed view ID 1781581385 with search condition 'ISABOUT (performance weight
(.8), </P>
<P>comfortable weight (.4), smooth weight (.2) )' failed with unknown result
(0x80020005).</P>
<DIV><FONT size=2>Does someone know why this error is throw?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Laurent</FONT></DIV>
<DIV> </DIV></FONT></FONT></DIV></BODY></HTML>
 
 
 

failed with unknown result

Post by Hilary Cot » Sun, 08 Jan 2006 02:37:39

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.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/



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

 
 
 

failed with unknown result

Post by Lolo » Tue, 10 Jan 2006 17:51:19

Yes I can but not this query with ISABOUT


% XXXX@XXXXX.COM ...
 
 
 

failed with unknown result

Post by Lolo » Wed, 11 Jan 2006 22:41:45

his is a multi-part message in MIME format.


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" < XXXX@XXXXX.COM > a rit dans le message de news: XXXX@XXXXX.COM ...
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This work fine if I write the query <FONT
face="Times New Roman" color=#0000ff> </FONT>
<P>USE<FONT size=2> AdventureWorks</FONT><FONT color=#808080 size=2>;</FONT></P>
<P><FONT size=2>GO</P></FONT><FONT color=#0000ff size=2>
<P>SELECT</FONT><FONT size=2> Description</P></FONT><FONT color=#0000ff size=2>
<P>FROM</FONT><FONT size=2> Production</FONT><FONT color=#808080
size=2>.</FONT><FONT size=2>ProductDescription</P></FONT><FONT color=#0000ff
size=2>
<P>WHERE</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>CONTAINS</FONT><FONT color=#808080 size=2>(</FONT><FONT
size=2>Description</FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>
</FONT><FONT color=#ff0000 size=2>'ISABOUT (performance :0.8,comfortable
:0.4, smooth :0.2 )'</FONT><FONT size=2> </FONT><FONT color=#808080
size=2>);</P></FONT><FONT size=2>
<P>GO</P></FONT></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Lolo" <<A
href="mailto: XXXX@XXXXX.COM "> XXXX@XXXXX.COM </A>> a rit
dans le message de news: <A
href="mailto: XXXX@XXXXX.COM "> XXXX@XXXXX.COM </A>...</DIV>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>When I run the exemple from the BOL:</DIV>
<DIV><FONT color=#0000ff size=2>
<P>USE</FONT><FONT size=2> AdventureWorks</FONT><FONT color=#808080
size=2>;</FONT></P>
<P><FONT size=2>GO</P></FONT><FONT c