I have query like that
SELECT
Urun_ID
,Urun_Ad

Hi,
I am using Microsoft FullText search feature in my database for Searching
strings.
I want to use CASE statement in CONTAINS.

Surely an easy question for those in the know...
I have a contacts table, and I'd like to ensure uniqueness across
first/middle/last name fields.  Each field is an nvarchar(255) - as
such, I can't create a regular index because the combined index size

We are experiencing a couple of strange issues with FTI/FTS.
Our environment: W2K3x64 Clustered SQL 2005 SP 1(2 instances) 4GB Ram,
Dual Proc, lots of disk.
We have one table (currently 425,000 rows) that has a FTI on 6

We are planning on renting a dedicated server for two of our web
applications. I would appreciate it if someone could give us some
advice on the server requirements in terms of the CPU and RAM. Here's
our situation:

I must be missing something obvious. I'd like to write a query that
ranks the row containing the most unique keywords first, rather than
the row with the most keywords.
1) my user enters "red green blue"

I'd like to know if it's possible to implement the search '%word|phrase%'
with full text catalog.
I've tried with "...CONTAINS(FIELD,'"word|phrase"')" but I don't get the
same result as using "... FIELD LIKE '%word|phrase%'".

For the past two weeks, we've been having MAJOR problems with the full
text features of SQL 2005 on one particular server which is resulting in
the hosted websites going offline at random intervals. These problems
include (in approx order of how often they occur):

In SQL 2005 does anyone know what the difference between a full text
catalogue "optimize" and a "populate" is? In 2000 I think there was only
populate.
It seems you can't schedule a normal "populate" in 2005 - only an

Ok I fixed the full text searching but now it wont update if I add a
new record and try to do a freetext search on it nothing comes back

I would like to see if anyone knows what the prereq's are to install
sql 2005 advanced and to be able to use the full text indexing
capability. I have just a xp workstation. I have IIS running. I
install full text per video 13 on microsofts education site but it

We've been using the catalog as part of our search engine for a year
now. We use freetexttable to search for keywords and it is fine until
now. For some reason the 'freetexttable' is inconsistent.
I tried this query and I got a lot of rows.

Probably a complete FAQ/newbie question, but i'm not finding it (or
searching wrongly).
Suppose my user wants to do a search for two words, they want to do an
AND-search and they don't want to type in AND. i.e. 'John Smith'

We are using SQL Server 2000 and we are doing Full-Text Indexing on a table
that has 5 Text Columns (we have Full Text Indexing on these 5 columns).
There are around 1.5 million records in this table. And the size of the
Full-Text Catalog is around 1 GB.

We're using Full text indexing on a couple of small databases (maybe
50mb each). Three times in the last week, I've had customers compain
that their websites are unresponsive or have SQL timeout error messages
when performing a search which uses FT.