none
Windows Search 4.0 does not search content of .sql files

    Question

  • On several computers running Windows XP Professional, Windows Search 4.0 does not seach the content of Microsoft SQL Server Query files (.sql) even though there is a file type definition for .sql files to be searched using the Plain Text filter.  Here is the configuration setting found on the File Types tab of the Advanced Options dialog:

     

    Extension: sql

    Filter Description: Plain Text filter

    How should this file be indexed? Index Properties and File Contents

     

    Also, in the registry:

     

    My Computer\HKEY_CLASSES_ROOT\.sql\PersistentHandler

    (Default) [REG_SZ] = {5e941d80-bf96-11cd-b579-08002b30bfeb}

     

    Before installing Windows Search 4.0, the computer was using Indexing Service.  Indexing Service did index files of this type and searching content was successful.

     

    Microsoft SQL Server Query files are text files with Transact SQL code.

     

    Is Windows Search 4.0 hard-coded to ignore these settings?  Should Windows Search 4.0 be able to search files of this file type?  If so, what is missing in this configuration?

     

    Thanks in advance.

    Sunday, October 12, 2008 4:00 PM

All replies

  • .sql file type is not in the list of searchable file types. See the list:

    http://www.microsoft.com/windows/products/winfamily/desktopsearch/technicalresources/filetypes.mspx

    There are some add-ins created for Windows Search, but .sql file type is not one of them, yet. There was a forum to express our wants for add-ins.  So I posted that I wanted an add-in for .sql files.
    Friday, November 06, 2009 5:58 PM
  • If the .sql files are in a text format then the text ifilter should process them and they should be searchable {if it's a binary format this won't work}. The index does need to be rebuilt after changing the file type indexing settings - Joe, have you tried rebuilding the index?

    Dave Wood
    Friday, November 06, 2009 7:33 PM
  • If the .sql files are in a text format then the text ifilter should process them and they should be searchable {if it's a binary format this won't work}. The index does need to be rebuilt after changing the file type indexing settings - Joe, have you tried rebuilding the index?

    Dave Wood

    Simply add the following keys to the registry in addition to the Persistent Handler one mentioned above. Then re-index. Viola!

    Computer\HKEY_CLASSES_ROOT\.sql

    Name: Content Type
    Type: String
    Value: text/plain

    Name: PerceivedType
    Type: String
    Value: text

    • Proposed as answer by tesmerjg Friday, October 12, 2012 12:57 PM
    Friday, October 12, 2012 12:57 PM