contains and varbinary document types

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

n_o_s_p_a__m@mail.com - 14 Sep 2006 23:30 GMT

Hello All,

I was reading BOL, and I came across this statement:

"Many document types can be stored in a single varbinary(max), or xml
column. Microsoft SQL Server 2005 supports certain document types and
provides a filter for these types."

But I can't find any other info on which document types they are
talking about. Could someone please enlighten me on this?

Thanks,
KJ

Reply to this Message

Warren Brunk - 15 Sep 2006 05:37 GMT

run this query in management studio...

select * from sys.fulltext_document_types

Should return all the document types...

Signature

/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

> Hello All,
>
[quoted text clipped - 9 lines]
> Thanks,
> KJ

Reply to this Message

Hilary Cotter - 15 Sep 2006 11:59 GMT

There is an error in BOL. It should read

"Many document types can be stored in a single varbinary(max), and XML can
be stored in an xml column. Microsoft SQL Server 2005 supports certain
document types and provides a filter for these types."

You can also use sp_fulltext_service 'load_os_resources', 1
and
sp_fulltext_service 'verify_signature', 1

To load os ifilters, like the PDF ifilter. These iFilters must already be
installed on SQL Server.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.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

> run this query in management studio...
>
[quoted text clipped - 14 lines]
>> Thanks,
>> KJ

Reply to this Message