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...
>

DML delete issues

Hi all,

I'm trying to return a processed Excel XML document from a stored procedure.

The procedure pulls a template document in XML format from a table, inserts data using DML and returns the result. The problem I've hit is in removing worksheets from the document prior to returning it. Inserts work fine when I try to remove a worksheet everything hangs. I'm thinking this could be a namespace problem, but am at a loss.

A small example(assume that @.XML contains a standard ExcelXML document):

set @.XML.modify('declare namespace ss="urnchemas-microsoft-comfficepreadsheet";
declare namespace o="urnchemas-microsoft-comfficeffice";
declare namespace x="urnchemas-microsoft-comffice:excel";
delete (/ss:Workbook[1]/ss:Worksheet[1])')

Any help greatly appreciated...

Regards,

Andy

I tried your case (delete the first Worksheet from a excel file in 2003 xml format) and it works fine:

Code Snippet

declare @.x xml = '<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>jinghaol</Author>
<LastAuthor>jinghaol</LastAuthor>
<Created>2007-04-24T16:15:41Z</Created>
<LastSaved>2007-04-24T16:17:18Z</LastSaved>
<Company>Microsoft</Company>
<Version>12.00</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>12345</WindowHeight>
<WindowWidth>18960</WindowWidth>
<WindowTopX>120</WindowTopX>
<WindowTopY>75</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"
x:FullRows="1" ss:DefaultRowHeight="15">
<Row>
<Cell><Data ss:Type="String">adsf</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"
x:FullRows="1" ss:DefaultRowHeight="15">
<Row>
<Cell><Data ss:Type="String">asdf</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1" ss:DefaultRowHeight="15">
<Row ss:Index="2">
<Cell><Data ss:Type="String">asdf</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>1</ActiveRow>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>'
select @.x
set @.x.modify('
declare namespace ss="urn:schemas-microsoft-com:office:spreadsheet";
declare namespace o="urn:schemas-microsoft-com:office:office";
declare namespace x="urn:schemas-microsoft-com:office:excel";
delete (/ss:Workbook[1]/ss:Worksheet[1])')
select @.x
go

I couldn't exactly copy/paste/run your query because the editor puts many and in namespace declare part.