January 10, 2017 at 3:13 pm
Hi All,
When I go to run command on my computer and type ssms,exe. It always navigates to this directory
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
and starts the ssms.exe from the above location.
I want that if I go to run command and Type ssms.exe then it should start ssms.exe from the below location.
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\Managementstudio\
I don't see any VSShell folder in the
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\Managementstudio\ location. How can I start ssms.exe from the 110 location rather than 100 location. I can always navigate to 110 location to start Sql server management studio, but from run command, it always goes to 100 location.
Is there any, I can change this.
January 10, 2017 at 3:32 pm
The long forgotten PATH command from MS-DOS days is very much alive still in Windows, just not as accessible. I bet that the path for the 100 is before the path for 110.
Go into the Control Panel, click on System, Advanced system settings, Environment Variables. Find the path variable, click on Edit and then rearrange the path such that 110 comes before 100. It would be a good idea to have a cmd window open and type SET PATH so you can see the complete path that you are working with. The small window that you edit in is not sizeable or easy to navigate.
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2017 at 3:34 pm
It looks like it's based on what the order of the paths in your environment variables. You'd want to check those and have the one you want to open first in the path. So
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\Managementstudio\
before
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply