Setting Defaults for QA

  • 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

  • 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]

  • Thanks

  • 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