How do I change the path in sys.fulltext_document_types

try to add (fix ) new entry in the PATH variable for  the IFilter DLL. (it is what the path in the sys.Fullltext_document_type table)

see more
http://blogs.msdn.com/ifilter/archive/2006/11/20/breaking-the-monolithic-filter-dll.aspx

From what I've read since posting the question, I find that I must update the field (column) for the row defining the path for the .mhtml doctype in the system catalog.  So, since I can't do an adhoc update, how DO i update the row in the system catalog table, sys.fulltext_doctypes.  I checked out the link you referred  me to.  that's for programmers.  I'm not doing programming.  I just need to alter this thing for a running production application.

you can not update system tables in sql server 2005 period.
 it looks like  IFilter setup (OS) related
Did you get any errors?
 I have  same .mhtml C:\WINDOWS\system32\%systemroot%\system32\mimefilt.dll   - so it maybe sql server 2005 bug (I have all sp\patches)
 so probalby search does not care about the table...
 
see
http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic14884.aspx 
"
that only gives the iFilters which ship with SQL Server 2005. If you choose
to load the ones via

exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go

you need to get a complete list via filtreg
" 
  filtreg.exe
http://msdn.microsoft.com/en-us/library/ms692537(VS.85).aspx
more:
Using Custom Filters with Indexing Service
http://msdn.microsoft.com/en-us/library/ms692577(VS.85).aspx 

So far, none of this looks very helpful.  You address the issue as if it was a programmer/developer issue.  I don't have filtreg.exe anywhere on our system.  Nor do I have any programming/development tools on this system.

so, how do we get the fulltext indexer to use the correct filter(?) from the correct location?

Does FiltReg FIX the problem?  How do I obtain this program?

from microsoft
--
It looks like a bug- you need to open MS PSS support  case
 
---
I just checked registry - the path  is there %systemroot%\system32\mimefilt.dll
 

Interesdting - MS will charge me $245 to report a bug - after they argue with me on the phone about wheether it is really abug or a figment of my imagination ...

did you get any error when you try to use this  .mhtml file type?

for - fre post bug at
http://connect.microsoft.com/default.aspx
you may need to wait - I am waiting for my posted bug anwser>8 weeks

ops sorry there was answer:
 
Dear Customer,
Thank you for the submission. currently we are unable to resolve this issue,we will look into this in the future.
---
So if it is real issue for you go for PSS
 

Microslop rides again ....

lloks like all in the regkey
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Filters
have normal path
sys.Fullltext_document_types
this one  .mhtml - is not here
 
maybe it is not the same case - however - you may get some good ideas ...
Extending SQL 2005 fulltext search
http://blogs.msdn.com/shajan/archive/2005/12/09/Extending-SQL-2005-Fulltext-Search.aspx 
 

hmm
maybe it just not installed for sql server like in the link above
 
check
http://www.citeknet.com/Products/IFilters/MHTIFilter/tabid/67/Default.aspx 

My krap-trapper said http://www.citeknet.com/Products/IFilters/MHTIFilter/tabid/67/Default.aspx is a security exposure - it identified the threat as : Exploit Javascript obfuscation (type 501) - have you got an alternate source?

try
http://www.brothersoft.com/mht-ifilter-78651.html

check
HOW TO: Index Multipurpose Internet Mail Extension Hypertext Markup Language Files in SharePoint Portal Server
http://support.microsoft.com/kb/316040

I really don't understand how your last post connects with my problem of sqlserver2005 having incorrect info about where to locate the dll for the mime filter.
---------------------------------------------------------------------------
Meanwhile, I think I've got a generic solution to the problem.  See next post.