by Jacob Dulwort » Wed, 09 Jan 2002 01:52:39
select name from functions where contains('name','test')
Search on full-text catalog 'DBACatalog' for database ID
6, table ID 1365579903 with search condition 'this' failed
with unknown result (2f9f974).
Thanks, Jake
by Dinesh T » Wed, 09 Jan 2002 02:06:20
No need to put column name in quotes.
shld be...
select [name] from dbo.[functions] where contains([name],'test')
also, if you are searching with "this" , the error may be because "this" is
a noise word.
PS:I enclosed the sql key words in square brackets..not compulsary, but
helps.
Dinesh.
Quote:> Has anyone seen an error like the one below? If you have,
> what can be done to fix it. The query is below as well.
> select name from functions where contains('name','test')
> Search on full-text catalog 'DBACatalog' for database ID
> 6, table ID 1365579903 with search condition 'this' failed
> with unknown result (2f9f974).
> Thanks, Jake
by Jacob Dulwort » Wed, 09 Jan 2002 02:27:40
Thanks for the quick reply. I put the wrong query in my
original post. The query is below. I still get the same
error when I execute it.
select name from functions where contains(name,'tests')
>No need to put column name in quotes.
>shld be...
> select [name] from dbo.[functions] where contains
([name],'test')
>also, if you are searching with "this" , the error may be
because "this" is
>a noise word.
>PS:I enclosed the sql key words in square brackets..not
compulsary, but
>helps.
>Dinesh.
message
>> Has anyone seen an error like the one below? If you
have,
>> what can be done to fix it. The query is below as well.
>> select name from functions where contains('name','test')
>> Search on full-text catalog 'DBACatalog' for database ID
>> 6, table ID 1365579903 with search condition 'this'
failed
>> with unknown result (2f9f974).
>> Thanks, Jake
>.
by Dinesh T » Wed, 09 Jan 2002 03:24:21
I just had a trial run and it works fine for me...
is it only with "tests" or for all searches?
is the ms search service running?
Dinesh.
> Thanks for the quick reply. I put the wrong query in my
> original post. The query is below. I still get the same
> error when I execute it.
> select name from functions where contains(name,'tests')
> >-----Original Message-----
> >Jacob,
> >No need to put column name in quotes.
> >shld be...
> > select [name] from dbo.[functions] where contains
> ([name],'test')
> >also, if you are searching with "this" , the error may be
> because "this" is
> >a noise word.
> >PS:I enclosed the sql key words in square brackets..not
> compulsary, but
> >helps.
> >Dinesh.
> message
> >> Has anyone seen an error like the one below? If you
> have,
> >> what can be done to fix it. The query is below as well.
> >> select name from functions where contains('name','test')
> >> Search on full-text catalog 'DBACatalog' for database ID
> >> 6, table ID 1365579903 with search condition 'this'
> failed
> >> with unknown result (2f9f974).
> >> Thanks, Jake
> >.
by Jacob Dulwort » Wed, 09 Jan 2002 03:33:53
Thanks,Jacob
>I just had a trial run and it works fine for me...
>is it only with "tests" or for all searches?
>is the ms search service running?
>Dinesh.
message
>> Dinesh,
>> Thanks for the quick reply. I put the wrong query in my
>> original post. The query is below. I still get the same
>> error when I execute it.
>> select name from functions where contains(name,'tests')
>> >-----Original Message-----
>> >Jacob,
>> >No need to put column name in quotes.
>> >shld be...
>> > select [name] from dbo.[functions] where contains
>> ([name],'test')
>> >also, if you are searching with "this" , the error may
be
>> because "this" is
>> >a noise word.
>> >PS:I enclosed the sql key words in square brackets..not
>> compulsary, but
>> >helps.
>> >Dinesh.
>> message
>> >> Has anyone seen an error like the one below? If you
>> have,
>> >> what can be done to fix it. The query is below as
well.
>> >> select name from functions where contains
('name','test')
>> >> Search on full-text catalog 'DBACatalog' for
database ID
>> >> 6, table ID 1365579903 with search condition 'this'
>> failed
>> >> with unknown result (2f9f974).
>> >> Thanks, Jake
>> >.
>.
by John Kan » Wed, 09 Jan 2002 07:28:18
If not, consider dropping the FT Catalog "DBACatalog" and re-create it and
run a Full Population and re-test your query. Note, this is a bug in SQL
Server 7.0 and the "un-known result" (2f9f974) is garbage data. If this
problem persists, consider opening a support case with Microsoft PSS SQL
Server Support.
Regards,
John
This posting is provided "AS IS" with no warranties, and confers no rights.
> Thanks,Jacob
> >-----Original Message-----
> >Jacob,
> >I just had a trial run and it works fine for me...
> >is it only with "tests" or for all searches?
> >is the ms search service running?
> >Dinesh.
> message
> >> Dinesh,
> >> Thanks for the quick reply. I put the wrong query in my
> >> original post. The query is below. I still get the same
> >> error when I execute it.
> >> select name from functions where contains(name,'tests')
> >> >-----Original Message-----
> >> >Jacob,
> >> >No need to put column name in quotes.
> >> >shld be...
> >> > select [name] from dbo.[functions] where contains
> >> ([name],'test')
> >> >also, if you are searching with "this" , the error may
> be
> >> because "this" is
> >> >a noise word.
> >> >PS:I enclosed the sql key words in square brackets..not
> >> compulsary, but
> >> >helps.
> >> >Dinesh.
> >> message
> >> >> Has anyone seen an error like the one below? If you
> >> have,
> >> >> what can be done to fix it. The query is below as
> well.
> >> >> select name from functions where contains
> ('name','test')
> >> >> Search on full-text catalog 'DBACatalog' for
> database ID
> >> >> 6, table ID 1365579903 with search condition 'this'
> >> failed
> >> >> with unknown result (2f9f974).
> >> >> Thanks, Jake
> >> >.
> >.
by Dinesh T » Wed, 09 Jan 2002 07:38:01
just curious...why is the online troubleshooter for FT queries at
http://support.microsoft.com/support/tshoot/sql7fts.asp offline ?
is there an alternative ?
thanks,
Dinesh.
> If not, consider dropping the FT Catalog "DBACatalog" and re-create it and
> run a Full Population and re-test your query. Note, this is a bug in SQL
> Server 7.0 and the "un-known result" (2f9f974) is garbage data. If this
> problem persists, consider opening a support case with Microsoft PSS SQL
> Server Support.
> Regards,
> John
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> > It is for all searches. The ms search service is running.
> > I have rebuilt the index many times and it still says the
> > same thing when you query against it. The server is SQL
> > 7.0 service pack 3 with the latest hot fix.
> > Thanks,Jacob
> > >-----Original Message-----
> > >Jacob,
> > >I just had a trial run and it works fine for me...
> > >is it only with "tests" or for all searches?
> > >is the ms search service running?
> > >Dinesh.
> > message
> > >> Dinesh,
> > >> Thanks for the quick reply. I put the wrong query in my
> > >> original post. The query is below. I still get the same
> > >> error when I execute it.
> > >> select name from functions where contains(name,'tests')
> > >> >-----Original Message-----
> > >> >Jacob,
> > >> >No need to put column name in quotes.
> > >> >shld be...
> > >> > select [name] from dbo.[functions] where contains
> > >> ([name],'test')
> > >> >also, if you are searching with "this" , the error may
> > be
> > >> because "this" is
> > >> >a noise word.
> > >> >PS:I enclosed the sql key words in square brackets..not
> > >> compulsary, but
> > >> >helps.
> > >> >Dinesh.
> > >> message
> > >> >> Has anyone seen an error like the one below? If you
> > >> have,
> > >> >> what can be done to fix it. The query is below as
> > well.
> > >> >> select name from functions where contains
> > ('name','test')
> > >> >> Search on full-text catalog 'DBACatalog' for
> > database ID
> > >> >> 6, table ID 1365579903 with search condition 'this'
> > >> failed
> > >> >> with unknown result (2f9f974).
> > >> >> Thanks, Jake
> > >> >.
> > >.
by John Kane [MS » Wed, 09 Jan 2002 13:35:55
> just curious...why is the online troubleshooter for FT queries at
> http://support.microsoft.com/support/tshoot/sql7fts.asp offline ?
> is there an alternative ?
> thanks,
> Dinesh.
> > Jacob,
> > Do you get similar errors with other FTS queries against other
databases?
> > For example, if you FT enable the pubs database and create a FT Catalog
on
> > the authors table and run a CONTAINS query do you get the same error?
> > If not, consider dropping the FT Catalog "DBACatalog" and re-create it
and
> > run a Full Population and re-test your query. Note, this is a bug in SQL
> > Server 7.0 and the "un-known result" (2f9f974) is garbage data. If this
> > problem persists, consider opening a support case with Microsoft PSS SQL
> > Server Support.
> > Regards,
> > John
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > It is for all searches. The ms search service is running.
> > > I have rebuilt the index many times and it still says the
> > > same thing when you query against it. The server is SQL
> > > 7.0 service pack 3 with the latest hot fix.
> > > Thanks,Jacob
> > > >-----Original Message-----
> > > >Jacob,
> > > >I just had a trial run and it works fine for me...
> > > >is it only with "tests" or for all searches?
> > > >is the ms search service running?
> > > >Dinesh.
> > > message
> > > >> Dinesh,
> > > >> Thanks for the quick reply. I put the wrong query in my
> > > >> original post. The query is below. I still get the same
> > > >> error when I execute it.
> > > >> select name from functions where contains(name,'tests')
> > > >> >-----Original Message-----
> > > >> >Jacob,
> > > >> >No need to put column name in quotes.
> > > >> >shld be...
> > > >> > select [name] from dbo.[functions] where contains
> > > >> ([name],'test')
> > > >> >also, if you are searching with "this" , the error may
> > > be
> > > >> because "this" is
> > > >> >a noise word.
> > > >> >PS:I enclosed the sql key words in square brackets..not
> > > >> compulsary, but
> > > >> >helps.
> > > >> >Dinesh.
> > > >> message
> > > >> >> Has anyone seen an error like the one below? If you
> > > >> have,
> > > >> >> what can be done to fix it. The query is below as
> > > well.
> > > >> >> select name from functions where contains
> > > ('name','test')
> > > >> >> Search on full-text catalog 'DBACatalog' for
> > > database ID
> > > >> >> 6, table ID 1365579903 with search condition 'this'
> > > >> failed
> > > >> >> with unknown result (2f9f974).
> > > >> >> Thanks, Jake
> > > >> >.
> > > >.
by John Kane [MS » Wed, 09 Jan 2002 13:40:46
> just curious...why is the online troubleshooter for FT queries at
> http://support.microsoft.com/support/tshoot/sql7fts.asp offline ?
> is there an alternative ?
> thanks,
> Dinesh.
> > Jacob,
> > Do you get similar errors with other FTS queries against other
databases?
> > For example, if you FT enable the pubs database and create a FT Catalog
on
> > the authors table and run a CONTAINS query do you get the same error?
> > If not, consider dropping the FT Catalog "DBACatalog" and re-create it
and
> > run a Full Population and re-test your query. Note, this is a bug in SQL
> > Server 7.0 and the "un-known result" (2f9f974) is garbage data. If this
> > problem persists, consider opening a support case with Microsoft PSS SQL
> > Server Support.
> > Regards,
> > John
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > It is for all searches. The ms search service is running.
> > > I have rebuilt the index many times and it still says the
> > > same thing when you query against it. The server is SQL
> > > 7.0 service pack 3 with the latest hot fix.
> > > Thanks,Jacob
> > > >-----Original Message-----
> > > >Jacob,
> > > >I just had a trial run and it works fine for me...
> > > >is it only with "tests" or for all searches?
> > > >is the ms search service running?
> > > >Dinesh.
> > > message
> > > >> Dinesh,
> > > >> Thanks for the quick reply. I put the wrong query in my
> > > >> original post. The query is below. I still get the same
> > > >> error when I execute it.
> > > >> select name from functions where contains(name,'tests')
> > > >> >-----Original Message-----
> > > >> >Jacob,
> > > >> >No need to put column name in quotes.
> > > >> >shld be...
> > > >> > select [name] from dbo.[functions] where contains
> > > >> ([name],'test')
> > > >> >also, if you are searching with "this" , the error may
> > > be
> > > >> because "this" is
> > > >> >a noise word.
> > > >> >PS:I enclosed the sql key words in square brackets..not
> > > >> compulsary, but
> > > >> >helps.
> > > >> >Dinesh.
> > > >> message
> > > >> >> Has anyone seen an error like the one below? If you
> > > >> have,
> > > >> >> what can be done to fix it. The query is below as
> > > well.
> > > >> >> select name from functions where contains
> > > ('name','test')
> > > >> >> Search on full-text catalog 'DBACatalog' for
> > > database ID
> > > >> >> 6, table ID 1365579903 with search condition 'this'
> > > >> failed
> > > >> >> with unknown result (2f9f974).
> > > >> >> Thanks, Jake
> > > >> >.
> > > >.
1. Error when creating fulltext index on a table
Im running SQL Server 7 with SP 2 on Windows 2000 Server with SP1 and get
an errormessage when I try to
create a fulltext index (have tried on every database except on the
systemdatabases)
Can't find anything about it on technet or MSDN
The errormessage is:
"An unknown full-text failure (80004005) occurred in
function EnumCatalogs on full-text catalog"
Would be pleased if someone could help me out on this?
// Patrik.
3. FullText Indexing of Text Documents
4. beeper and SQL server(v6.0)?
5. Scheduling of fulltext index rebuild problem
7. FullText index populating is slow ?
9. fulltext index population is too late..
10. fulltext index after export
11. Fulltext Index
12. fulltext index population is too late..