J'ai trouble getting Windows Search to index the contents of a text fichier that have a `.sql` extension. Is there quelque chose I'm doing wrong?
## Contexte:
I use a programme at work called *Navicat* which helps me to work avec our MySQL database. When I use Navicat to edit and save queries, it stores them in `.sql` fichiers which are located in Navicat's répertoire in Program Files.
Depuis Windows Search ne index fichiers within Program Files par défaut, I added it vers le list of indexed locations, as shown dans le picture below:
J'ai aussi went invers le advanced section and added the `.sql` fichier extension and sélectionner the `Index Properties and File Contents` option. This sets the filter description to be `Plain Text Filter`:
Cependant, whenever I do a search for text that I would expect to find within a `.sql` fichier, such as `saw_order.Wo type:sql`, it ne return any fichiers. The search **is** successful if I'm searching for part du *name* of a fichier, but jamais its contents avec `.sql` fichiers.
The `.sql` fichiers are plain text fichiers that can be easily opened and edited avec notepad. Navicat simply adds some intellisense and a organization fonctionnalités, but other than that, c'est plain text.
Pourquoi ne puis-je pas Windows Search see the contents duse fichiers?
Do J'ai besoin de add some special plug-in to Windows search for it to recognize these fichiers?
*NOTE: Je suis using Windows Search 4.0 and Windows XP SP3.*
Windows Recherche Not Indexing Contents of Text Fichiers Avec .SQL Extension
Re: Windows Recherche Not Indexing Contents of Text Fichiers Avec .SQL Extension
Il semble que il y a a problème avec Windows Search reading the format du fichier, even when set in plain text. C'est a [known problem](http://social.msdn.microsoft.com/Forums/en-IE/windowsdesktopsearchhelp/thread/30abcfe7-7891-4793-9f03-c6fed4f1f99b) and has even been brought up [here on Superuser](https://superuser.com/questions/77772/windows-desktop-search-fails-to-search-inside-sql-files)!
My best recommendation for maintenant is to use a programme that can search the contents of fichiers. It may not be as fast as having them indexed, but hopefully it can get the job done for you.
Four great tools I recommend:
**[Agent Ransack](http://www.mythicsoft.com/agentransack/)** (freeware):
**[NirSoft SearchMyFiles](http://www.nirsoft.net/utils/search_my_files.html)** (freeware and portable):
**[Windows Grep](http://www.wingrep.com/download.htm)**:
**[Portable File Seeker](http://www.softpedia.com/get/PORTABLE-SOFTWARE/System/File-management/Windows-Portable-Applications-Portable-File-Seeker.shtml)** (freeware):
My best recommendation for maintenant is to use a programme that can search the contents of fichiers. It may not be as fast as having them indexed, but hopefully it can get the job done for you.
Four great tools I recommend:
**[Agent Ransack](http://www.mythicsoft.com/agentransack/)** (freeware):
**[NirSoft SearchMyFiles](http://www.nirsoft.net/utils/search_my_files.html)** (freeware and portable):
**[Windows Grep](http://www.wingrep.com/download.htm)**:
**[Portable File Seeker](http://www.softpedia.com/get/PORTABLE-SOFTWARE/System/File-management/Windows-Portable-Applications-Portable-File-Seeker.shtml)** (freeware):