Windows Explorer search file contents not working on .sql files.

Dear Experts,

I hate to have to post such a seemingly dumb question. But all the obvious has not worked.

My new XP Pro laptop was recently configured for me. After installing Teradata SQL Assistant, the .SQL files were opening with that. But, that was not what I wanted to use. In Windows, I like to use wordpad.

I work with Oracle scripts, with the suffix: .SQL. There are hundreds of them.

Like most people, I often forget which file contains what. So, I usually use Windows Explorer search to find the file. If I know that the file is concerning GV$PROCESS, I just use windows explorer to search all files for that keyword. Usually this works fine.

But, explorer doesn't find a thing in any one of my .SQL files. Not even the SELECT keyword, which is in almost ALL of them.

I've done the obvious. In Windows explorer. Tools, folder Options. file types. change it to: notepad, wordpad, and even MS Word (which usually works).

The file will open with the app that I change it to.

However, any search for the contents for the contents of files, will always return zero files found!!!

Searching through the registry has not shown anything obvious.

What is the secret to fix this???

Thanks a lot. Received on Wed May 18 2005 - 10:01:42 CDT