Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  Full-text search of image col not working

Author  Topic  Dennis Starting Member 11 Posts Posted - 2007-03-20 : 10:05:17 Hi everybody, I uploaded a txt file into a table with an IMAGE column. When I full-text index it, I can't get any results. A look in the crawl log shows this: (I'm running sqlsrv 2005 - 9.00.2047.00 - SP1 - Developer Edition ---------- 2007-03-20 14:59:59.83 spid25s The component 'sqlfth90.dll' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\90\COM\sqlfth90.dll'. 2007-03-20 14:59:59.83 spid25s Informational: Full-text retry pass of Full population completed for table or indexed view '[frombjorn].[dbo].[dfvd_filedata]' (table or indexed view ID '1977774103', database ID '12'). Number of retry documents processed: 1. Number of documents failed: 1. 2007-03-20 15:00:00.47 spid24s Informational: Full-text Auto population initialized for table or indexed view '[frombjorn].[dbo].[dfvd_filedata]' (table or indexed view ID '1977774103', database ID '12'). Population sub-tasks: 1. -------------- The table def is: CREATE TABLE [dbo].[dfvd_filedata]( [dfvd_recno] [int] NOT NULL, [dfvd_filedata] [image] NULL, [dfvd_format] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK__dfvd_filedata__047AA831] PRIMARY KEY CLUSTERED ( [dfvd_recno] ASC ) The script to create the index is: CREATE FULLTEXT INDEX ON [dbo].[dfvd_filedata] KEY INDEX [PK__dfvd_filedata__047AA831] ON [my_ft_cat] WITH CHANGE_TRACKING AUTO GO ALTER FULLTEXT INDEX ON [dbo].[dfvd_filedata] ADD ([dfvd_filedata] TYPE COLUMN [dfvd_format]) GO ALTER FULLTEXT INDEX ON [dbo].[dfvd_filedata] ENABLE GO I created a file in notepad on my local disk called "dennis.txt" and inserted it into the table with: INSERT INTO dfvd_filedata(dfvd_recno,dfvd_format, dfvd_filedata) SELECT 1,'.txt',* FROM OPENROWSET(BULK N'c:\temp\dennis.txt', SINGLE_BLOB) AS dfvd_filedata ----- Anybody know why this data can't be indexed? Believe me, I've searched and searched and searched and can't find any solutions... thanks to the guru that can help me :)