New Query with Current Connection

16 Mar 2006 7:45 PM

Bojan Kuhar

I am missing "New Query with Current Connection" button in SQL Editor in the
SQL management studio. Few posts on the Web refer explain that this button
should allow me to open a new query in the existing window.

I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.

Any ideas?

16 Mar 2006 9:15 PM

Steen Persson (DK)

Bojan Kuhar wrote:

> I am missing "New Query with Current Connection" button in SQL Editor in the
> SQL management studio. Few posts on the Web refer explain that this button
> should allow me to open a new query in the existing window.
>
> I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.
>
> Any ideas?

I'm not sure it can be done, but "Ctrl-N" will give you the "New query
with current connection".

Regards
Steen

17 Mar 2006 6:39 AM

Bojan Kuhar

Fantastic.

Now, one more. Is there something like "Open Query with Current Connection".
I'd like to avoid the Connect to Database Enginde dialog.

More-less like Qury Analyzer that allows you to open a new query in the
existing window.

Regards

Bojan

Show quote

"Steen Persson (DK)" wrote:

> Bojan Kuhar wrote:
> > I am missing "New Query with Current Connection" button in SQL Editor in the
> > SQL management studio. Few posts on the Web refer explain that this button
> > should allow me to open a new query in the existing window.
> >
> > I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.
> >
> > Any ideas?
> I'm not sure it can be done, but "Ctrl-N" will give you the "New query
> with current connection".
>
> Regards
> Steen
>

19 Mar 2006 3:03 PM

Erland Sommarskog

Bojan Kuhar (BojanKu***@discussions.microsoft.com) writes:

> Fantastic.
>
> Now, one more. Is there something like "Open Query with Current
> Connection". I'd like to avoid the Connect to Database Enginde dialog.
>
> More-less like Qury Analyzer that allows you to open a new query in the
> existing window.

What Steen said, CTRL-N is the key. Provided one thing: under Tools->
Options->Keyboard select SQL 2000 instead of Standard.

The New Query button also works if you are in a query window or Object
Explorer, and so does File->New->Query with Current Connection.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

17 Mar 2006 4:49 PM

Rick Byham [MS]

My fault. The button was called New Query with Current Connection in one of
the betas. The released version renamed it to New Query. I changed most of
the references, but I missed a few. I think I got rid of them all by web
release 1 of Books Online though.
The New Query button will use the connection that has focus when you click
it. Either Object Explorer, or an existing Query Editor window. If your
current context has no connection, then it will pop up the Connect to Server
dialog box.

--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

Show quote

"Bojan Kuhar" <BojanKu***@discussions.microsoft.com> wrote in message
news:01230DB5-BEE5-4452-B89E-470DCCE488F2@microsoft.com...
>I am missing "New Query with Current Connection" button in SQL Editor in
>the
> SQL management studio. Few posts on the Web refer explain that this
> button
> should allow me to open a new query in the existing window.
>
> I've checked "Add Remove Buttons" for SQL editor but I still cannot find
> it.
>
> Any ideas?