Red Gate forums :: View topic - "Containing Text" searches not working
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Aardvark
Aardvark forum

"Containing Text" searches not working

Search in Aardvark forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Scott Willhite
Guest





PostPosted: Thu Feb 26, 2004 8:38 pm    Post subject: "Containing Text" searches not working Reply with quote

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?


Back to top
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Fri Feb 27, 2004 3:33 pm    Post subject: Re: "Containing Text" searches not working Reply with quote

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?
>
>


Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group