 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / May 2008sql 2000 sp4 image iflter issue
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 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. >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 [quoted text clipped - 17 lines] > Thanks, > Shawn > That is for SQL Server 2005. For SQL Server 2000 you look at C:\Program > Files\Microsoft SQL Server\MSSQL$instanceName\FTdata\SQLServer\Gathererlogs [quoted text clipped - 22 lines] > > - Show quoted text - 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? > That is for SQL Server 2005. For SQL Server 2000 you look at C:\Program > Files\Microsoft SQL Server\MSSQL$instanceName\FTdata\SQLServer\Gathererlogs [quoted text clipped - 22 lines] > > - Show quoted text - Figured out how to the viewer but the logs list no errors. Did you want to post the word doc here or send it to me offline? >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 [quoted text clipped - 17 lines] > Thanks, > Shawn > >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 [quoted text clipped - 19 lines] > > - Show quoted text - 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? That is what I am wondering. Can you export it to the file system and open it up? On May 8, 1:28 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote: > Did you want to post the word doc here or send it to me > offline?"LongbowShawn" <sda...@longbowtech.com> wrote in message [quoted text clipped - 24 lines] > > - Show quoted text - 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? > That is what I am wondering. Can you export it to the file system and open > On May 8, 1:28 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote: [quoted text clipped - 35 lines] > > - Show quoted text - It does open as a word doc. 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. On May 8, 7:48 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote: > That is what I am wondering. Can you export it to the file system and open > it up?"LongbowShawn" <sda...@longbowtech.com> wrote in message [quoted text clipped - 37 lines] > > - Show quoted text - It does open as a word doc. > Can you send it to me offline or post it here. I have some tools which allow > On May 8, 7:48 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote: [quoted text clipped - 44 lines] > > - Show quoted text - 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.