"duke" <vallidaniele@hotmail.com> wrote in message
news:1156763947.790127.231180@74g2000cwt.googlegroups.com...
> Yes, I add a type column and I reference it in my full-text index.
>
> With:
>
> SELECT * FROM sys.fulltext_indexes JOIN sys.tables
> ON sys.tables.object_id = sys.fulltext_indexes.object_id
> WHERE sys.tables.name = 'tblTest'
>
> I can see my full-text index. But it returns 0 rows if I serach a known
> word.
> I tried with ppt-files and word-files. I have always the same result =>
> 0 rows.
>
> What could be the problem?
>
> Thanks for help.
>
>
> Hilary Cotter schrieb:
>
>> It should be. Did you add a column which contains the document type ie
>> (.ppt)? And when you created your full-text index, did you reference this
>> document type column, ie
>>
>> CREATE FULLTEXT INDEX ON MyTableName
>> (VarBinaryColumn TYPE COLUMN VarBinaryColumnExtension )
>> KEY INDEX index_name
>> -- Hilary CotterDirector of Text Mining and Database
>> StrategyRelevantNOISE.Com - Dedicated to mining blogs for business
>> intelligence.
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>>
>>
>> "duke" <vallidaniele@hotmail.com> wrote in message
>> news:1156421597.468168.291070@75g2000cwc.googlegroups.com...
>> > Hi,
>> > I have installed SQL Server 2005 Express Edition with Advanced Services
>> > and I tried to process a full-text search on a varbinary or image
>> > column. I insert in this column ppt-files.
>> > But it returns always 0 rows, although I searched some words that are
>> > inserted in my ppt-files.
>> > On text based columns it works well.
>> >
>> > My question are:
>> > -It is really possible to process a full-text search on a varbinary
>> > column with this version of SQL Server(Express Edition with Advanced
>> > Services)?
>> > -If yes, what could be the problem?
>> >
>> > Thanks in advance
>> > duke
>> >
>