"Containing Text" searches not working
Brian Donahue
Posts: 6,590 Bronze 1
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?
>
>
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?
>
>
This discussion has been closed.
