Search through the contents of any file on your computer and your SQL schema (table definitions, stored procedures, functions, triggers and views definitions) using this lightweight application
Version: 2.0Need to find a file that contains specific words in a large pile of files and folders on your computer? this program can help you find it quickly.
Operating System: Windows
For programmers, it can also help find sql server objects that contain specific words.
One scenario is a regular user trying to find all the files that contain one or more keywords, simply check the folder checkbox, enter the folder path you like to search, or multiple folder paths separated by a semicolon, type one or more keywords to search and hit the Search button. A list of all the files that contain all those keywords is displayed, selecting one of the match files will display the contents as plain text, highlighting the search words.
You can further search within the displayed contents for any other words using the simple Ctrl-F shortcut. There is also a cool right click menu with additional features that you can explore.
The second scenario is a programmer who wants to make a change to the definition of a sql server table by changing the name of one field, so he needs to study the impact of that change on all existing code. Simply check both the folder and SQL checkboxes in the program.
Enter the path to your source code, or multiple paths separated by a semicolon, and enter the sql server name and login credentials, then enter what you want to search for, possibly the field name that you want to change and the table name, and hit the Search button.
The program will display a list of all source code files that contain those search keywords, it will also list all sql server tables, functions, stored procedures, triggers and views that contain those search keywords. Now it's easy to analyze the results.
The program only displays the results and there are no side effects like editing the files or the sql objects.
Another scenario is a programmer who wants to check the definition of a sql server table, just launch the program, type the table name, and voila.
Version 2.0: Program is now free.
Version 1.0: Initial release