Full text index not created on varbinary(max) - sql 2008   

Hi

Full text query on varbinary(max) column is not returning results, as the 
index is not populated.
Some configuration error - can't figure out what.
FDHost process has no issues

The log shows this -  Informational: Full-text Auto population completed for 
table or indexed view '<name>' (table or indexed view ID '<id>', database ID 
'<id>'). Number of documents processed: 0. Number of documents failed: 0. 
Number of documents that were retried: 0.

Any insights into this issue?

-- 
Thanks,
Sameeksha
MCAD.Net

date: Tue, 15 Jul 2008 06:05:02 -0700   author:   Sameeksha

Re: Full text index not created on varbinary(max) - sql 2008   

Sameeksha,

Since this is varbinary(max) I do not believe that the standard text parser 
will work on it.

Have you made sure that the document extension is stored in an additional 
column (referred to as a document type column), and that your full-text 
index is configured to use this document type column? If so, then you would 
have values like doc for Word documents, xls for Excel Spreadsheets, pdf for 
PDFs, and so on.

Also, you need iFilters for some datatypes that are not natively supported 
by SQL Server.  For example, Adobe has an iFilter for PDFs.

RLF

"Sameeksha"  wrote in message 
news:39B43A55-3454-4D30-AA75-E39892D3088D@microsoft.com...
> Hi
>
> Full text query on varbinary(max) column is not returning results, as the
> index is not populated.
> Some configuration error - can't figure out what.
> FDHost process has no issues
>
> The log shows this -  Informational: Full-text Auto population completed 
> for
> table or indexed view '<name>' (table or indexed view ID '<id>', database 
> ID
> '<id>'). Number of documents processed: 0. Number of documents failed: 0.
> Number of documents that were retried: 0.
>
> Any insights into this issue?
>
> -- 
> Thanks,
> Sameeksha
> MCAD.Net

date: Tue, 15 Jul 2008 18:06:07 -0400   author:   Russell Fields