sql 2000 sp4 image iflter issue - Hilary Cotter

That is for SQL Server 2005. For SQL Server 2000 you look at C:\Program
Files\Microsoft SQL Server\MSSQL$instanceName\FTdata\SQLServer\Gathererlogs

You need to use gthrlogs.vbs to read them.

sql 2000 sp4 image iflter issue - Hilary Cotter

Did you want to post the word doc here or send it to me offline?

sql 2000 sp4 image iflter issue - Hilary Cotter

That is what I am wondering. Can you export it to the file system and open
it up?

You think that the document might be corrupt?  I use an ole routine to
edit the document and place it into a variable which is then written
to the table. I think the data in the image column might contain some
kind of ole header.  Would that mess things up?  If so is there any
remedy?

sql 2000 sp4 image iflter issue - LongbowShawn

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
FROM Documents
WHERE FREETEXT (content, 'metzger');

and get no results although I have seeded a row with a word document
containing that text.  I've done several full populations of the
index.  No help...

Running a select against another non-image straight text column works
to retrieve text so I know the full-text engine is running.  I can't
seem to find the crawl logs even using this link as ref:
http://msdn.microsoft.com/en-us/library/ms142495.aspx.  How can I make
sure the engine is properly indexing the document in my image col and
any other troubleshooting advice would be great.

Thanks,
Shawn

sql 2000 sp4 image iflter issue - LongbowShawn

s

Thanks I noticed that too after I made my post.  But I don't use VB
I'm a PowerBuilder guy how else can I read the log?

sql 2000 sp4 image iflter issue - LongbowShawn

s

Figured out how to the viewer but the logs list no errors.

sql 2000 sp4 image iflter issue - LongbowShawn

You think that the document might be corrupt?  I use an ole routine to
edit the document and place it into a variable which is then written
to the table. I think the data in the image column might contain some
kind of ole header.  Would that mess things up?  If so is there any
remedy?

sql 2000 sp4 image iflter issue - Hilary Cotter

Can you send it to me offline or post it here. I have some tools which allow
me to see it as the iFilter see it.


It does open as a word doc.

sql 2000 sp4 image iflter issue - LongbowShawn

It does open as a word doc.

sql 2000 sp4 image iflter issue - LongbowShawn

ow
en
..


s

d

I have now setup an index a client table that has 250k records (60%
word 2000 docs) and still no results.  I'll send you a sample doc
offline.

How do I know that the .doc filter is installed?  Not sure if I said
before but this is sql 2000 sp4 running on server 2003.

Thanks - Shawn