I'm having trouble getting Windows Search to index the contents of a text file that have a .sql
extension. Is there something I'm doing wrong?
Background:
I use a program at work called Navicat which helps me to work with our MySQL database. When I use Navicat to edit and save queries, it stores them in .sql
files which are located in Navicat's directory in Program Files.
Since Windows Search does not index files within Program Files by default, I added it to the list of indexed locations, as shown in the picture below:
I also went into the advanced section and added the .sql
file extension and select the Index Properties and File Contents
option. This sets the filter description to be Plain Text Filter
:
However, whenever I do a search for text that I would expect to find within a .sql
file, such as saw_order.Wo type:sql
, it does not return any files. The search is successful if I'm searching for part of the name of a file, but never its contents with .sql
files.
The .sql
files are plain text files that can be easily opened and edited with notepad. Navicat simply adds some intellisense and a organization features, but other than that, it's plain text.
Why can't Windows Search see the contents of these files?
Do I need to add some special plug-in to Windows search for it to recognize these files?
NOTE: I am using Windows Search 4.0 and Windows XP SP3.