Open SSMS 2012 using RUN window

  • Hi,

    Just want to know what shortcut can we use to open SSMS 2012 as,

    we are using RUN(window + R) --> SSMS for 2K8

  • my SSMS for SQL 2012 is in this folder:

    "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

    My question for you is whether you want to Replace the current call for SSMS with the 2012 version, or have it available as a separate call?

    to make SSMS 2012 be "The One", you need to edit the path variables, removing the path to 2008 and replacing it with the folder for 2012

    if you want a separate call, you just need a shortcut, named for ease of use, in one of the folders in the path.

    if both 2012 and 2008 paths are already in, the call to SSMS finds the FIRST SSMS when searching the folders...so the order of the paths could be switched to get 2012 to answer "first"; you'd have to edit the path and put it back.

    For having a quick and easy call, here's one idea:

    Right Click on my computer and click properties. Click on the advanced Tab>> bottom right button is environmental variables

    you cna also go to a cmd prompt and do echo %path%+

    those are the folders in the path.

    in any of the folders identified in the path, create a shortcut to the SSMS2012 path like i posted above.

    name the shortcut "SS2012" or whatever you want to be able to type to differentiate between your 2008 that is currently in the path,and the 2012.

    now if you Start>>Run or Windows>>R and type SS2012, it opens the SSMS related to 2012.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Hi Lowell ,

    Thanx for reply.

    worked for me.... 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply