Post reply

SSMS command switches + Object Explorer?

  • June 22, 2011 at 2:51 pm

    #149123

    Is there a way to launch SSMS (2005) with command line switches and have it observe the general option to "Open Object Explorer and new query"? I use this:

    "C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" -E -D foo

    ... to log into my 'foo' database with Windows Authentication, however the Object Explorer doesn't connect as before I added the switches.

  • June 24, 2012 at 12:29 pm

    #1504840

    I am having the same problem with ssms 2008 R2.

  • June 24, 2012 at 7:06 pm

    #1504870

    You don't need command line switches for this. Click on {Tools}{Options}{General} and discover what's in the first drop down box.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 25, 2012 at 6:08 am

    #1504998

    on {Tools}{Options}{General} I have tried open in Object Explorer and Open in Object Explorer and new Query and neither works.

    Object Explorer is not populated.

    Please note that this problem is when I run the command line on my server that has SQL Server 2008 R2 installed. If I run the command line from a client computer running XP sp3 it works and both Object Explorer and a new Query window are shown.

    Thanks

    Howard

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

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