Using SQL Server Management Studio efficiently - Finding content in Files
SQL Server Management Studio is one of the most widely used editor for Microsoft SQL Server. Search is an important features we need most of the time. While using MS Management Studio we often need to search on file. This article demonstrates how to do in easy steps.
We can easily search content from the query in 'New Query Window' but what if we want to search the files containing the search content from a bunch of files. Here are the steps to do so and I hope it will help the developers.
Step 1
Press Ctrl + F to bring the 'Find' window. Type the content to search for.
Step 2
Click 'Quick Find' and then 'Find in Files'.
Step 3
Click on 'Look in' box from the pop up window.
Step 4
A new window will appear and it lists the drives in your computer. Select the drive where you want to search files.
Step 5
After selecting the drive go to the folder location and click on the '>' (arrow) mark.
Step 5
Click on 'Find All'
Now the search result will be listed. Click and check the files from the list.
Hope it will be helpful. Your feedback will be highly appreciated.