Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a command line option like devenv.exe /Edit for Sql Server Management Studio

I'm using visual studio's external tools to open .sql scripts in Sql Server Management Studio (SSMS). The problem is, each time I use the external tools command to open a .sql file from visual studio, it opens a new instance of SSMS.

Visual Studio has a switch /Edit that will do this, is there one for SQL Server Management Studio?

like image 331
TheEmirOfGroofunkistan Avatar asked Apr 16 '09 19:04

TheEmirOfGroofunkistan


People also ask

How do I edit SQL Server Management Studio?

Using SQL Server Management Studio In Object Explorer, expand the database that contains the view and then expand Views. Right-click the view and select Edit Top 200 Rows. You may need to modify the SELECT statement in the SQL pane to return the rows to be modified.

How do you run the Devenv command?

For example, "c:\project a\" . Insert one space character between switches and arguments on the same line. For example, the command devenv /log output. txt opens the IDE and outputs all log information for that session to output.

Where is Devenv EXE config?

devenv.exe. config resides in C:\Program Files (x86)\Microsoft Visual Studio X. 0\Common7\IDE by default (it is recommended to create a backup copy before modifying it).


2 Answers

Choose to open the file with Explorer[1] instead of SSMS. That way the system will search for any existing instances of SSMS first.

[1] %windir%\explorer.exe

like image 89
KevinT Avatar answered Oct 04 '22 04:10

KevinT


I don't think the problem is with Visual Studio external tool command. Look at SSMS command line options - maybe there is a way to force reusing existing SSMS instance.

like image 25
Juozas Kontvainis Avatar answered Oct 04 '22 04:10

Juozas Kontvainis