Hello Guys, Yes
it may be possible that you have to install both version because in one server
only 2008 work but in another server ot another client have SERVER 2012 then
off course you have both in your local server. But lets suppose you have
installed SQL Server 2008 and after some day or some month you installed SQL
Server 2012 After installation when you open SQL Server with run command then
its opened the 2008 not new version or vice versa. Then i have the query to
open SQL Server as you want.
Code Sample [SQL Server
Query]
Go to run and paste
below command
For SQL Server 2008
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
And the 2012 management studio exe is here:
"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
You can also open this by go to above mention path like
C=>Program Files (x86)=>Microsoft SQL Server=>100=>Tools=>Binn=>VSShell=>Common7=>IDE
and click the ssms
For SQL Server 2008
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
And the 2012 management studio exe is here:
"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
You can also open this by go to above mention path like
C=>Program Files (x86)=>Microsoft SQL Server=>100=>Tools=>Binn=>VSShell=>Common7=>IDE
and click the ssms
Output
