Opening a SQL file from the VS Find Results window opens the file twice in two SSMS instances

Question

I set up a screencast here to make the problem clearer: http://screencast.com/t/SZo8QGuQv

I have installed SQL Server Management Studio 2012 as the default program to open .sql files from Visual Studio 2013.

When I search for solutions in Visual Studio that returns SQL files, opening any of these results opens the file twice in two separate SSMS instances.

This is a bit of a nuisance, but I have been doing this for many years - on several computers and in several versions of Windows, VS and SSMS - and I can’t understand what causes this.

Answer 1

Well

there is a preview in the "Find Result" window to select an item

When you select one VS element, try to preview to double-click two events.

• Preview
• open

the result is two smss examples.

In the test, to close smss, it deletes my sql file, so use this Visual Studio trick . Open the SQL file using SQL Management Studio in an existing SSMS window. explorer to open the file.

Finally, I couldn’t do as you need, but it has one option

in "open with.." i set "Microsoft SQL Server Data Tools, T_SQL Editor"
in "browse with.." i set "Windows Explorer"

after the option "Browse with" is added in the context menu of Result

here the context menu and the option "Browse with .."

and this is the result

http://www.screencast.com/t/MZFrUlvB4KYh