Re: Treatment of extension column changed in SP4?

Sorry, Glen,
I forgot to post the KB articles, they're listed below that were published
after SP3 was released:
327217 (Q327217) INF: Installing SQL Server 2000 Service Pack 3 Rebuilds All
Full-Text Catalogs
http://support.microsoft.com/default.aspx?scid=kb;en-us;327217

312410 (Q312410) "FIX: Full Text RANK Results May Vary After Catalog
Repopulation"
http://support.microsoft.com/default.aspx?scid=kb;en-us;312410 (references
Q240867)

317486 (Q317486 ) "FIX: A Query That Uses a Large Search String in the
CONTAINS Clause May Fail with Error Msg 7607"
http://support.microsoft.com/default.aspx?scid=kb;en-us;317486

323039 (Q323039) FIX: Full-Text Search Population of a Word Document Stored
in SQL Server Causes CPU Spin with SQL Server 2000 Service Pack 2
http://support.microsoft.com/default.aspx?scid=kb;en-us;323039

321332 (Q321332) "FIX: Full-Text Searches for Data That is Enclosed in
Parenthesis() Inside HTML Tags is Not Being Returned"
http://support.microsoft.com/default.aspx?scid=kb;en-us;321332

321820 (Q321820) "FIX: Non-OCR/Non-Display TIFF Data Indexed by SQL Server
Full-Text"
http://support.microsoft.com/default.aspx?scid=kb;en-us;321820

You still might want to try opening a support case with MS PSS SQL Server
support as they do have the means to do extended logging (much more than
with your debug build & very specific to SQL Server FTS) and who knows, they
may declare it a bug as it breaks your custom IFilter post-SP3 and then the
support case will be free!

As for the MSSearch service finding the right Ifilter for a file with no or
an unknown extension, I don't believe this is possible, but if it is, then
you may want to try making the following registry key/value changes for
unknown extensions:

Unknown Extensions
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/ixufilt_9vg3.asp

FilterFilesWithUnknownExtensions
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/ixrefreg_2r8z.asp

Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


<glenlow@xxxxxxxxxxxxx> wrote in message
news:1129099929.315654.270410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Could I get the URLs to the KB's please?
>
> The file extension column is populated with ".doc.gz" etc. and the
> datatype is VARCHAR(10).
>
> I can confirm the MSSearch service is launching my IFilter because my
> debug builds have logging built in. I wrote a quick revision that
> manages to decompress the file, but of course when passing the
> decompressed (and now extensionless) file to LoadIFilter to find a
> suitable filter, it fails with a 0x80070057 error. (Pre-SP4 this worked
> most swimmingly.) Is the IFilter system smart enough to find the right
> filter when there is no extension?
>
> Cheers,
> Glen Low, Pixelglow Software
> www.pixelglow.com
>


.

Relevant Pages

  • Re: Hotfix Post SP4
    ... Build 2148, to fix the SQLDiag issue, but also fixes another 10 or so. ... to fix the Query Analyzer DTC issue. ... SQL Server Version Database ... You receive an error message if you use the sp_addalias or sp_dropalias ...
    (microsoft.public.sqlserver.clustering)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... Earl Newcomer wrote: ... >fix of 1*value and it works as you mentioned. ... As far as I can tell, so long as SQL Server has to do an arithmetic ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 SP4 - realease date
    ... it looks like SP4 is targeted for the first half ... there is no "fix" with UMS non-yielding processes ... New concurrency and scheduling diagnostics added to SQL Server: ... FIX: You are prompted for password confirmation after you change a standard ...
    (microsoft.public.sqlserver.server)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... fix of 1*value and it works as you mentioned. ... To answer your question about copying between SQL Server instances I don't ... will copy between SQL Server tables carrying with it the incorrect sign bit. ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: Register custom IFilter to FilterFilesWithUnknown Extensions?
    ... the default iFilter is used. ... Looking for a SQL Server replication book? ... > Unknown Extensions, instead the default filter? ...
    (microsoft.public.inetserver.indexserver)