What are the challenges you face when working across database platforms? Take the survey

"Containing Text" searches not working

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited February 27, 2004 9:33AM in Aardvark
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.


Brian Donahue
Red Gate Technical Support

"Scott Willhite" <mrswoop@tough.net> wrote in message
> For some reason, searches are not responding to the "containing text"
> in custom searches. There is not error message, just the "no matching
> issues were found" message. However, this message is received regardless
> what is searched on... it never returns anything.
> Other searches seem to be working fine.
> Ideas?
This discussion has been closed.