Post reply

Setting Defaults for QA

  • March 15, 2004 at 7:47 am

    #82247

    Is there any way to set a default server and database for Query Analyzer? I would to have a connection to my development server made automatically when I open the tool.

    TIA

    Dean

  • March 15, 2004 at 7:59 am

    #498749

    Default for the server is the last one you connected to.

    Default db you set via sp_defaultdb.

    One out of two is not bad

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • March 15, 2004 at 8:20 am

    #498775

    Thanks

  • March 16, 2004 at 12:27 pm

    #499023

    You can create a shortcut to the file isqlw.exe (Query Analyzer) and sending as parameter the server and database.

    isqlw -S ServerName -D DBName -U UserName -P Password

     

    See "isqlw Utility" in BOL.

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

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