Hello everybody. I have MS SQL 2000 with SP4 installed on 2003 win server. I
can search doc files stored in image data type column, but I can NOT search
xml files. Could you help me please? Thank you very much. I have heard about
micorosft xml ifilter, but every links to this ...

I have multiple full-text catalogs on about 8 tables (sql server 2005 ee -
all varchar(max)).
A few days ago, they all went to an idle status and won't start picking up
any new changes - all catalogs are auto update.

I have 2 different queries that I expected to return the same results.
Where Name like '%fish%'
and
Where contains((Name),'("*fish*")')

Need some help with this. On a simple search I use the syntax;
----------------
where title like'%#1%'
---------------

Is it possible to get statistics of any sort from the full text engine?
My understanding is SQL Server treats the the fulltext engine as a remote
server and performs distributed queries against it via oledb. AFAIK, oledb
has optional interfaces to obtain stats (cardinality, ...

Lets say i have a table TITLES with columns ID,INDEKS,TEKST
Values in row are
ID    INDEKS        TEKST
1    World War    II Day by Day

Is there a way to grab a bit of text near the first word the fulltext
search matches?
We're currently showing a summary to people, which is written by the
user, but obviously does not contain the keyword someone searched for.

This is cross posted to sqlserver.prgramming also...
I am confused by the MSDN help regarding the Contains clause for fulltext
search.
The Help states that the single-quote does not need to be escaped for

I have a Full-text Search query as mentioned below.
SELECT * FROM CONTAINSTABLE(TABLE_NAME, COL_Name,
N'ISABOUT(FORMSOF(INFLECTIONAL, TEXT_HERE))') ORDER BY Rank DESC
The table, TABLE_NAME contains around 800 rows and the column COL_Name is

I have a table which has several fulltext enabled columns.
Title, Summary, Description
I was wondering whether it is possible to assign some kind of weight
to the columns? For example, I find it more relevant if the keywords

Folks,
   Just a quick one. How do you determine the user that the full text
service is using on SQL Server 2000? Any suggestions/code sample
diagnostics much appreciated.

Hi, could anyone tell me how to extract all the indexed keywords from the SQL
server catalog of indexes please?

How to genericaly search the entire db for any text string in any stored
procedure, function, table definition, agent job, etc. Any one command or
anyone have a stored proc that does this wide search?

Folks,
   Please help! I am unable to create a full-text catalogue. When I
run the following command:
sp_fulltext_catalog 'Cat_Desc', 'create', 'f:\VENUS_SQL_DAT\MSSQL

Hello,I have been trying some methods of querying different columns using a
2005 full text
catalog.http://technet.microsoft.com/en-gb/library/ms345119.aspx#yukonftsea_topic5e.g.1
SELECT pk, txtCol2, txtCol3