Open SQL Server 2012 From Command Prompt

问题:

I have installed SQL Server 2012, SQL Server 2008 R2 and SQL Server 2014.

Now when I run SSMS it always opens SQL Server 2008.

What to do same for SQL Server 2012?

Any shortcut key or command to run from command prompt like SSMS?

Please guide me.

回答1:

I found the solution. It is so simple.

Just create desktop short cut and copy that file to C:\Windows\

For example:

Create short cut named as on desktop SQL Server Management Studio Now simply copy it to your C:\Windows path and rename it to SSMS12 and now from command prompt simply type SSMS12 -

It will open SQL Server 2012.