Link to home
Start Free TrialLog in
Avatar of Calvin Day
Calvin DayFlag for United States of America

asked on

SQL 2005 Ever New Query Opens Connect Dialog

The "Microsoft SQL Server Management Studio" opens a connection dialog with every new query. Please tell me there is setting to prevent this.


Thanx in advance.

Greg
Avatar of harisrashid
harisrashid
Flag of Denmark image

hi,

you should register the server on which databases reside that are referred in your query.

Regards,

Haris
right click database ->select 'New query'
Avatar of Calvin Day

ASKER

Got all that.

In SQL 2000 once the “Query Analyzer” was open, each new query would automatically open to the prior database server connection and database.

SQL 2005 spans a Connect Dialog every time a new query file is started or opened.
Avatar of imran_fast
imran_fast

EITHER CLICK ON NEW QUERY BUTTON
OR USE THIS KEY

<CTRL>+<N>
ASKER CERTIFIED SOLUTION
Avatar of simonsabin
simonsabin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Simon,

Thanx Again,

G