Joined: 23 Aug 2004
Location: Red Gate Software
|Posted: Fri Feb 27, 2004 3:33 pm Post subject: Re: "Containing Text" searches not working
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.
Red Gate Technical Support
"Scott Willhite" <firstname.lastname@example.org> 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.
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521