"Containing Text" searches not working

Forum for users of Aardvark bug tracking system

Moderator: Brian Donahue

Re: "Containing Text" searches not working

Postby Brian Donahue » Fri Feb 27, 2004 3:33 pm

Hi Scott,

What 'edition' of SQL Server do you use? Some editions, like MSDE, for
instance, do not support full-text catalogues, and hence don't support
CONTAINS() queries. If you had a full-text catalogue and it was corrupted
for whatever reason, you would have got an error message on the search page
rather than no results.

If you've got a fully-featured SQL Server, check under the Aardvark
database's 'full text' catalogues and make sure you've got a catalogue
called Bugs. If it's not there, you can re-create it by opening SQL Query
Analyzer and opening and running the Aardvark\SQL\FTS.sql file.

Regards,

Brian Donahue
Red Gate Technical Support

"Scott Willhite" <mrswoop@tough.net> wrote in message
news:skiTVCK$DHA.1468@server53...
> For some reason, searches are not responding to the "containing text"
field
> in custom searches. There is not error message, just the "no matching
> issues were found" message. However, this message is received regardless
of
> what is searched on... it never returns anything.
>
> Other searches seem to be working fine.
>
> Ideas?
>
>
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Return to Aardvark

Who is online

Users browsing this forum: No registered users and 0 guests