SQL files are ignored in the search

[Hilberty]

The searched string is found in CPP and H files, but not in SQL files. Why is
this format not treated as text files ? Enhanced Google Desktop Search allow
to enter extensions treated as text files.

Is there a work around ?

[John Kane]

Hilberty,
I've seen this behavior as well and I have many, many .sql files I
previously had FT Indexed by the Indexing Service! There is an Indexing
Service utility (Filtreg.exe) that can be downloaded from the Platform SDK
that can be used to set filtering of one file type (.sql) to be the same as
another (.txt), and I had this working via:

filtreg .sql .txt

filtreg
-- Edited output returns for .sql:
...
.sql --> Plain Text filter (query.dll)
...

Now after upgrading MSN Desktop Search to the current release, the following
query returns 0 results: "dbcc ext:sql" and there are many .sql files on my
hard drive that have dbcc in them! I suspect that this is some sort of a
regression bug, but I too would like to get a workaround until this can be
fixed!

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

"Hilberty" <Hilb...@discussions.microsoft.com> wrote in message
news:63621496-8A98-469F...@microsoft.com...

[Hilberty]

Sorry. Which attached file ?

Regards

"Hilary Cotter" wrote:

> save the attached file. Double click on it. Rebuild your index.
>
> --
> 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

>
> "Hilberty" <Hilb...@discussions.microsoft.com> wrote in message
> news:63621496-8A98-469F...@microsoft.com...

[Hilary Cotter]

use Outlook Express or another non web based newsreader to download this
file.

Here are the contents:
----------------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\RSSearch\ContentIndexCommon\Filters\E
xtension\.sql]
@=hex(7):7b,00,41,00,33,00,37,00,33,00,46,00,33,00,44,00,34,00,2d,00,37,00,4
2,\

00,38,00,37,00,2d,00,31,00,31,00,44,00,33,00,2d,00,42,00,31,00,43,00,31,00,\

2d,00,30,00,30,00,43,00,30,00,34,00,46,00,36,00,38,00,31,00,35,00,35,00,43,\
00,7d,00,00,00,00,00
----------------------------

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

"Hilberty" <Hilb...@discussions.microsoft.com> wrote in message

news:53E177D4-30A0-4D02...@microsoft.com...