Sunday, October 4, 2015

How to open both 2008 and 2012 sql server on same machine

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

Output








No comments:

Post a Comment