Do i need to activate some types in sys.fulltext_document_types

hi all;
I heard that I have to activate some supported types for full-text search;
like if I want to search in HTML document (.html) I have to activate the
search for HTML or PDF and so, and what is the types activated by default.
When I retrieve all the types by:
select * from sys.fulltext_document_types
Does this command include all the activated types or I have to activate some
of it.
Thank you
It includes all the signed ones. To "activate" the 3rd party iFilters, like
Adobe's PDF iFilter you need to download the iFilter, install it and then do
the following.
Exec Sp_fulltext_service 'load_os_resources', 1
Exec Sp_fulltext_service 'verify_signature', 0
Hilary Cotter
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
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:%236shPnTGHHA.1232@.TK2MSFTNGP05.phx.gbl...
> hi all;
> I heard that I have to activate some supported types for full-text search;
> like if I want to search in HTML document (.html) I have to activate the
> search for HTML or PDF and so, and what is the types activated by default.
> When I retrieve all the types by:
> select * from sys.fulltext_document_types
> Does this command include all the activated types or I have to activate
> some of it.
> Thank you
>
>
|||Thank you Hilay for the reply ;
can i get info about the signed ones; and what do u mean by 3rd party
iFilters what is the second party; what is included by default and what is
not .
thank you
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eQ$qidUGHHA.3304@.TK2MSFTNGP05.phx.gbl...
> It includes all the signed ones. To "activate" the 3rd party iFilters,
> like Adobe's PDF iFilter you need to download the iFilter, install it and
> then do the following.
> Exec Sp_fulltext_service 'load_os_resources', 1
> Exec Sp_fulltext_service 'verify_signature', 0
> --
> Hilary Cotter
> 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
>
> "yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
> news:%236shPnTGHHA.1232@.TK2MSFTNGP05.phx.gbl...
>
|||Thank you (Hilary) for the reply ;
can i get info about the signed ones; and what do u mean by 3rd party
iFilters what is the second party; what is included by default and what is
not .
thank you
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:%2337nvxUGHHA.1280@.TK2MSFTNGP04.phx.gbl...
> Thank you Hilay for the reply ;
> can i get info about the signed ones; and what do u mean by 3rd party
> iFilters what is the second party; what is included by default and what is
> not .
> thank you
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eQ$qidUGHHA.3304@.TK2MSFTNGP05.phx.gbl...
>
|||A Second party developer has an exclusive with a company and makes products
only for that one company. A third party developer is not tied to a company
and makes products for a varitey of companies.
Here are the list of iFilters installed by default
MSPFILT.DLL - ms paper ifilter - extracts text from tiffs - does ocr
VISFILT.DLL - visio ifilter
nlhtml.dll - html
offfilt.dll - office ifilter
msfte.dll - text ifilter
xmlfilt.dll - xml ifilter
mimefilt.dll - mime, email, and news ifilter
tquery.dll - this is the null iFilter, it extracts summary properties for
other search products like Indexing Services, I am unsure what its role is
here.
xmlfilter.dll - xml iFilter
Hilary Cotter
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
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:O2GhFMdGHHA.4112@.TK2MSFTNGP04.phx.gbl...
> Thank you (Hilary) for the reply ;
> can i get info about the signed ones; and what do u mean by 3rd party
> iFilters what is the second party; what is included by default and what is
> not .
> thank you
> "yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
> news:%2337nvxUGHHA.1280@.TK2MSFTNGP04.phx.gbl...
>