SSMS Search in Project or Solution opens EVERY file - even if they don't match the search string

%3CLINGO-SUB%20id%3D%22lingo-sub-2904048%22%20slang%3D%22en-US%22%3ESSMS%20Search%20in%20Project%20or%20Solution%20opens%20EVERY%20file%20-%20even%20if%20they%20don't%20match%20the%20search%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904048%22%20slang%3D%22en-US%22%3E%3CP%3EWhenever%20I%20search%20for%20text%20in%20my%20project%20or%20solution%2C%20SSMS%20opens%2C%20and%20keeps%20open%2C%20every%20file%20it%20searches%20whether%20or%20not%20the%20search%20string%20was%20found.%3C%2FP%3E%3CUL%3E%3CLI%3EE.g.%20Say%20I%20have%20references%20to%20a%20particular%20table%20in%20perhaps%203%20or%204%20SQL%20scripts%20in%20my%20project.%20If%20I'm%20making%20a%20change%20to%20that%20table%2C%20I%20need%20to%20find%20those%20scripts%20to%20see%20if%20they%20also%20need%20to%20be%20changed.%20Obviously%20I%20don't%20want%20to%20open%20any%20other%20files.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20search%20for%20some%20text%2C%20%3CSTRONG%3ESSMS%20opens%20EVERY%20script%20and%20%3CFONT%20color%3D%22%23FF0000%22%3Eleaves%20it%20open%3C%2FFONT%3E%3C%2FSTRONG%3E.%20Half%20way%20through%20the%20process%2C%20SSMS%20is%20taking%20up%20so%20much%20memory%20that%20it%20becomes%20unresponsive%20and%20crashes.%3C%2FP%3E%3CUL%3E%3CLI%3EIn%20contrast%2C%20Visual%20Studio%20only%20ever%20keeps%20open%20those%20files%20that%20match%20the%20search.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIt's%20got%20so%20bad%20I%20can%20no%20longer%20use%20Search%20within%20Project%20or%20Solution.%20I'm%20having%20to%20do%20a%20search%20in%20windows%20File%20Explorer%2C%20make%20a%20note%20of%20the%20files%20that%20need%20looked%20at%2C%20and%20then%20open%20each%20separately.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20believe%20that%20every%20other%20user%20is%20happy%20with%20this%2C%20so%20it%20makes%20me%20think%20there%20must%20be%20something%20wrong%20with%20my%20setup.%20I%20have%20reinstalled%20SSMS%20several%20times%20now%2C%20but%20to%20no%20effect.%20Help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

0 Replies