Windows XP Search and SQL Script Files 1

[jcmercure]

Hello -

I have an Windows XP Professional PC and I have a large quantity of SQL Scripts files that have '.SQL' as the extension. These are pure text files, nothing fancy.

I need to be able to search the files from the OS level for various text strings when updates are needed. Windows XP Search does not appear to search the contents of these files, even is SQL Script Files are specifically selected as the file type.

A week ago these files were on my old WinNT system and there was no problem with the Find functionality in this regard.

I did a test and changed the file extension to '.TXT'. The Search function worked just fine after that. I don't want the solution to be to switch the file extention.

Windows XP file associations recognize these files as 'Notepad' files. Why won't the search function examine the contents?

Any help is appreciated. Thanks.

- John

 

[bonifale]

I had the problem with .sct files.

This worked for me. I googled it up from somewhere that I don't recall.

Run REGEDIT
Open HKEY_CLASSES_ROOT
Open file extension (.sql)

If PersistentHandler key does not exist
Highlight file extension and click Edit->New->Key
Name the key PersistentHandler
Open .sql->PersistentHandler
Double click (Default)
Enter value {5e941d80-bf96-11cd-b579-08002b30bfeb}
Exit regedit
Reboot


hope this helps

 

[jcmercure]

bonifale -

Thanks for the tip. This worked perfectly and I have passed the registry entry onto my co-workers. How did you find this solution?

- John

 

[bonifale]

Glad it helped.

I can't remember exactly where I found it but there are more details at

http://support.microsoft.com/default.aspx?scid=KB;en-us;309173&

It's easier when you know the answer already. Have a google for the key value 5e941d80-bf96-11cd-b579-08002b30bfeb and quite a lot of wisdom arrives.