Hi, I am using the WITH FREETEXT command against my database.
The problem I am having is that the WITH FREETEXT treats seperate
words passed in using an OR
so instead of getting a search for 'Guitar AND Player AND America' I

I'm trying to get the Adobe filer to work on a SQL 2005 x64, but I can't get
it to work.
I have downloaded the bits from
(http://labs.adobe.com/wiki/index.php/PDF_iFilter_8_-_64-bit_Support and

I have 2 tables that I would like to implement full text indexing on.  I'm
just not sure if I should use incremental or change log updating.
Each table has 12 fields,  I am only implementing the full text index on 1
column in each table.  There will likely be around 4 - 8 inserts ...

I am using SQl server 2005 64 Bit Service Pack 2 with Full text on one table
and only on one field.
When I run query on my table of 800,000 rows Full text search find 4830
records within 18 seconds with skill Oracle in State CA.

I have sql server 2005 x64 standard version.  english version windows 2003.
I have a company table with a column "company name" and create a fulltext
index on this column, collision is swedish.
for example, there are 5 cases value in this column, like following:

I understand from other posts that special characters should be converted
into words (example % should be changed to percent).
I am trying to work with a plus sign (example find product names like 33+)
I tried changing the + to plus (and to "append" and to "add") but nothing

Is it possible to do a full text catalogue on an indexed view in SQL 2000?
It looks like you can only do tables and the functionality for indexed views
is in SQL 2005, is this correct?
Thanks

I'm having some difficulties as to which approach is the right one in
this scenario:
I have a table of books (tblShopItem), a table of categories (authors,
series etc. = tblShopCategory) and a table that connects these

Can I use a stored procedure as table inside a stored procedure?
for eg. i have a stored procedure named QMENU and QNEWMENU
I want to use these two stored procedures in another stored procedure like:
CREATE PROCEDURE MENU(@roll1 as INT)

I have just migrated from SQL Server 2005 to SQL Server 2008 Beta
I have a single table q_docversion  with 1000 records
(
f_Doc_ID int PK

I have table with an image column that stores word documents. I added
a cloumn called "DocumentType" and poulate it with .doc. I used the
wizard to setup an FT index.  I run a select staement like this one:
SELECT document_name

Hi,
 To enable support of FTS of multiple languages, we are using neutral word
breaker in ms sql 2000 for our application.
 Unfortunately, there seems to be a limitation in the word breaker. It does

Is there a way to retrieve to full list of single characters (symbols)
that are ignored by the FT indexing service?
I am using the British English language (ID 2057) and while it is
pretty simple to get the list of noise words, I wouldn't know where to

What is the easiest way to migrate full text indexes from SQL2K to SQL2K5?