"Containing Text" searches not working

[Scott Willhite]

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]

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 AardvarkSQLFTS.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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521