sql 2000 sp4 image iflter issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.

Relevant Pages

  • Re: sql 2000 sp4 image iflter issue
    ... "LongbowShawn" wrote in message ... >I have table with an image column that stores word documents. ... > to retrieve text so I know the full-text engine is running. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How do I customize fax cover sheet?
    ... Word MVP web site http://word.mvps.org ... > I need to fax one or several Word documents under custom cover page. ... How do I customize cover page in order to use it in Fax Wizard? ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Inserting fields from Excel
    ... That sure is easier than that wizard in the tools menu. ... Mail Merge item to display the Mail Merge toolbar. ... word documents with these fields on them. ... I have tried to play around using mail merge but it's not working out ...
    (microsoft.public.word.newusers)
  • How can I link a Visio shape to a word document? (non-Data type)
    ... Looks like in Visio, Data files can be easily linked using ... the Wizard. ... I have couple of Word documents in 'My Documents' folder, ...
    (microsoft.public.visio.general)