New Query with Current Connection

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?

Bojan Kuhar  wrote:
> I am missing "New Query with Current Connection" button in SQL Editor in t
he
> SQL management studio. Few posts on the Web refer explain that  this butto
n
> 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 i
t.
>
> Any ideas?
I'm not sure it can be done, but "Ctrl-N" will give you the "New query
with current connection".

Regards
Steen

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


"Steen Persson (DK)" wrote:

> Bojan Kuhar wrote: 
> I'm not sure it can be done, but "Ctrl-N" will give you the "New query
> with current connection".
>
> Regards
> Steen
>

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.

"Bojan Kuhar" < BojanKuhar@discussio
ns.microsoft.com> wrote in message
news:01230DB5-BEE5-4452-B89E- 470DCCE488F2@microso
ft.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?

Bojan Kuhar  (BojanKuhar@discussi
ons.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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx