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

distributed transaction

does the following error causes any problem to activate distributed
transaction.
My sp which runs on XXXXXX pushes data from XXXXXX to YYYYY. With the BEGIN
TRAN enabled the Sp hangs. it works fine when i comment the begin/ commit
trans. it take only 5 sec to execute.
Both XXXXXX and YYYYY runs on VMWare virtual machine
Event Type:Error
Event Source:NETLOGON
Event Category:None
Event ID:5516
Date:23/10/2006
Time:15:50:48
User:N/A
Computer:XXXXXX
Description:
The computer or domain XXXXXX trusts domain YYYYY. (This may be an indirect
trust.) However, XXXXXX and YYYYY have the same machine security identifier
(SID). NT should be re-installed on either XXXXXX or YYYYY.
Data:
0000: 01 04 00 00 00 00 00 05 ......
0008: 15 00 00 00 8a 5a 41 60 ...?ZA`
0010: 93 e3 62 48 43 17 0a 32 ??bHC..2
thanks
Just a guess: Are the operating systems derived from the same installation? If so, perhaps the DTC
services has the same GUID... You could try the last step of
http://www.karaszi.com/SQLServer/inf...rver_name.asp, just make sure you have backup etc
first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:7D24D271-D90F-495B-9AC8-8821B8A01E9A@.microsoft.com...
> does the following error causes any problem to activate distributed
> transaction.
> My sp which runs on XXXXXX pushes data from XXXXXX to YYYYY. With the BEGIN
> TRAN enabled the Sp hangs. it works fine when i comment the begin/ commit
> trans. it take only 5 sec to execute.
> Both XXXXXX and YYYYY runs on VMWare virtual machine
> Event Type: Error
> Event Source: NETLOGON
> Event Category: None
> Event ID: 5516
> Date: 23/10/2006
> Time: 15:50:48
> User: N/A
> Computer: XXXXXX
> Description:
> The computer or domain XXXXXX trusts domain YYYYY. (This may be an indirect
> trust.) However, XXXXXX and YYYYY have the same machine security identifier
> (SID). NT should be re-installed on either XXXXXX or YYYYY.
> Data:
> 0000: 01 04 00 00 00 00 00 05 ......
> 0008: 15 00 00 00 8a 5a 41 60 ...?ZA`
> 0010: 93 e3 62 48 43 17 0a 32 ??bHC..2
> thanks
>

distributed transaction

does the following error causes any problem to activate distributed
transaction.
My sp which runs on XXXXXX pushes data from XXXXXX to YYYYY. With the BEGIN
TRAN enabled the Sp hangs. it works fine when i comment the begin/ commit
trans. it take only 5 sec to execute.
Both XXXXXX and YYYYY runs on VMWare virtual machine
Event Type: Error
Event Source: NETLOGON
Event Category: None
Event ID: 5516
Date: 23/10/2006
Time: 15:50:48
User: N/A
Computer: XXXXXX
Description:
The computer or domain XXXXXX trusts domain YYYYY. (This may be an indirect
trust.) However, XXXXXX and YYYYY have the same machine security identifie
r
(SID). NT should be re-installed on either XXXXXX or YYYYY.
Data:
0000: 01 04 00 00 00 00 00 05 ......
0008: 15 00 00 00 8a 5a 41 60 ...?ZA`
0010: 93 e3 62 48 43 17 0a 32 ??bHC..2
thanksJust a guess: Are the operating systems derived from the same installation?
If so, perhaps the DTC
services has the same GUID... You could try the last step of
http://www.karaszi.com/SQLServer/in...erver_name.asp, just make sure
you have backup etc
first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:7D24D271-D90F-495B-9AC8-8821B8A01E9A@.microsoft.com...
> does the following error causes any problem to activate distributed
> transaction.
> My sp which runs on XXXXXX pushes data from XXXXXX to YYYYY. With the BEGI
N
> TRAN enabled the Sp hangs. it works fine when i comment the begin/ commit
> trans. it take only 5 sec to execute.
> Both XXXXXX and YYYYY runs on VMWare virtual machine
> Event Type: Error
> Event Source: NETLOGON
> Event Category: None
> Event ID: 5516
> Date: 23/10/2006
> Time: 15:50:48
> User: N/A
> Computer: XXXXXX
> Description:
> The computer or domain XXXXXX trusts domain YYYYY. (This may be an indire
ct
> trust.) However, XXXXXX and YYYYY have the same machine security identif
ier
> (SID). NT should be re-installed on either XXXXXX or YYYYY.
> Data:
> 0000: 01 04 00 00 00 00 00 05 ......
> 0008: 15 00 00 00 8a 5a 41 60 ...?ZA`
> 0010: 93 e3 62 48 43 17 0a 32 ??bHC..2
> thanks
>

distributed transaction

does the following error causes any problem to activate distributed
transaction.
My sp which runs on XXXXXX pushes data from XXXXXX to YYYYY. With the BEGIN
TRAN enabled the Sp hangs. it works fine when i comment the begin/ commit
trans. it take only 5 sec to execute.
Both XXXXXX and YYYYY runs on VMWare virtual machine
Event Type: Error
Event Source: NETLOGON
Event Category: None
Event ID: 5516
Date: 23/10/2006
Time: 15:50:48
User: N/A
Computer: XXXXXX
Description:
The computer or domain XXXXXX trusts domain YYYYY. (This may be an indirect
trust.) However, XXXXXX and YYYYY have the same machine security identifier
(SID). NT should be re-installed on either XXXXXX or YYYYY.
Data:
0000: 01 04 00 00 00 00 00 05 ......
0008: 15 00 00 00 8a 5a 41 60 ...Â?ZA`
0010: 93 e3 62 48 43 17 0a 32 �ãbHC..2
thanksJust a guess: Are the operating systems derived from the same installation? If so, perhaps the DTC
services has the same GUID... You could try the last step of
http://www.karaszi.com/SQLServer/info_change_server_name.asp, just make sure you have backup etc
first.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:7D24D271-D90F-495B-9AC8-8821B8A01E9A@.microsoft.com...
> does the following error causes any problem to activate distributed
> transaction.
> My sp which runs on XXXXXX pushes data from XXXXXX to YYYYY. With the BEGIN
> TRAN enabled the Sp hangs. it works fine when i comment the begin/ commit
> trans. it take only 5 sec to execute.
> Both XXXXXX and YYYYY runs on VMWare virtual machine
> Event Type: Error
> Event Source: NETLOGON
> Event Category: None
> Event ID: 5516
> Date: 23/10/2006
> Time: 15:50:48
> User: N/A
> Computer: XXXXXX
> Description:
> The computer or domain XXXXXX trusts domain YYYYY. (This may be an indirect
> trust.) However, XXXXXX and YYYYY have the same machine security identifier
> (SID). NT should be re-installed on either XXXXXX or YYYYY.
> Data:
> 0000: 01 04 00 00 00 00 00 05 ......
> 0008: 15 00 00 00 8a 5a 41 60 ...Â?ZA`
> 0010: 93 e3 62 48 43 17 0a 32 �ãbHC..2
> thanks
>