I am creating a stored procedure to help my users find products in our
webshop. When they enter there search term, they can search for ALL the
words, ANY of the words, or the EXACT search term.
This is what I have so far:

I'm not very familiar with fulltext search sintax, so I need your help..
In the contains statement I'd like to make a search like:
'FORMSOF (THESAURUS, "*long*") near FORMSOF (THESAURUS, "string*")'
but I get syntax error, any help?

I am new to Full-Text search and learning about it.
I am having an issue with the number of rows retrieved.
The 1st query shown below
[code]Select Ai_Id,Ai_Texto FROM  tblAvisosInternet

I have a free text catalog in sql server 2005 indexing a table with
several millions of rows.
The full rebuilt will take more than 50 hours.
The database is used 9:00 to 18:00.

I would like to create a SELECT statement that returns a certain range of
the results that a WHERE clause returns. For example, if the WHERE clause
would return 75 records, I want a way to have the SELECT statement return
the second 10 records, or the third 10 records, etc. I ...

Full text query on varbinary(max) column is not returning results, as the
index is not populated.
Some configuration error - can't figure out what.
FDHost process has no issues

Morning all,
I'm having problems with my FTS rankings on our SQL2005 database and I'm a
bit stumped as where to start looking at what the the problem might be.
The simplified SQL is as follows:

If I execute a query such as this one, I get back records that contain
"DaVinci" in AddressLine1 column and "Kirkland" in the City column:
select ft.id, ft.name, Line1, Line2, Line3, line4, city, county
from company as ft

Don't know if this is the right forum...
Anyways I need some help with constructing a SELECT query:
The table below is an example:
WONUMBER    PARENT    AMOUNT    HASCHILDREN

Hi friends, and sorry for my english.
I have a SQL Server 2000 with severals databases which hold more than 210
full text catalogs.
Recently, after create the last 3 DBs with 10 catalogs each, when the

I am trying to create a full text catalog on sql server 2008 feb CTP. The
create command executes successfully, however, the catalog does not get
associated with the filegroup specified in the create command. Trying to open
properties of the catalog results in error that ...

Can you tell me why a prefix search like:
SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"n*"')
(<column1> is a "nvarchar")
returns not only records containing text beginning with "n", but also

Hi Team,
Configuration:
SQL Server 2000 SP4
Clustered - Active / Passive