Whenever I search for text in my project or solution, SSMS opens, and keeps open, every file it searches whether or not the search string was found.
- E.g. Say I have references to a particular table in perhaps 3 or 4 SQL scripts in my project. If I'm making a change to that table, I need to find those scripts to see if they also need to be changed. Obviously I don't want to open any other files.
When I search for some text, SSMS opens EVERY script and leaves it open. Half way through the process, SSMS is taking up so much memory that it becomes unresponsive and crashes.
- In contrast, Visual Studio only ever keeps open those files that match the search.
It's got so bad I can no longer use Search within Project or Solution. I'm having to do a search in windows File Explorer, make a note of the files that need looked at, and then open each separately.
I can't believe that every other user is happy with this, so it makes me think there must be something wrong with my setup. I have reinstalled SSMS several times now, but to no effect. Help?
