Launch SSMS from command prompt

  • Hi,

    How do we launch 2012 SSMS from command prompt? I was using ssms.exe to launch 2008 SSMS also googled and found we can use ssms.exe for 2012 ssms also. But in my system both 2008 and 2012 installed. But when I use ssme.exe the 2008 ssms is opening.

    Even I tried with the the instance name with -S switch. So it is opening in 2008 ssms.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

  • use the entire path when trying to call 2012 ssms

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

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • If you wanted to have the 2012 SSMS open with just ssms.exe you can reorganize you "path" environment variable. move "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio" the the beginning of the string or at least before the path of the 2008 executable.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • use the entire path when trying to call 2012 ssms

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

    Jason, Thanks. It is working.

    If you wanted to have the 2012 SSMS open with just ssms.exe you can reorganize you "path" environment variable. move "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio" the the beginning of the string or at least before the path of the 2008 executable.

    Bob, Yes, it would be good. But I didn't understand.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

  • For the suggestion Bob made, here is an article showing how to do it.

    http://www.computerhope.com/issues/ch000549.htm

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 1 through 4 (of 4 total)

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