SQL Editor Hangs on sql cmd

[Database Administrator]

Hello, and thanks for your assistance in advance. I am running Sql Server
2008 Express with advanced services. Every time I run a sql script, it just
hangs.....the action line just shows "Debugging Query". There are no other
errors or problems. Any query does this. I have reinstalled twice and same
thing.

Thanks,
chris

[Database Administrator]

Are you hitting F5 or the "!" icon (execute button)? Or are you hitting the
debug button (looks like a green "play" icon)? One of the first things I do
when I install a new copy of 2008 SSMS is customize the toolbar and get that
debug button out of there. It reminds me of Query Analyzer's "execute"
button and to be honest if I ever have a need for debugging in SSMS I will
be able to handle going through a menu to get to it.

A





On 10/27/08 1:24 PM, in article
BD15779E-4E96-4D9B-B884-7DB711B43137@microsoft.com, "TJ"
wrote:

> Hello, and thanks for your assistance in advance. I am running Sql Server
> 2008 Express with advanced services. Every time I run a sql script, it just
> hangs.....the action line just shows "Debugging Query". There are no other
> errors or problems. Any query does this. I have reinstalled twice and same
> thing.
>
> Thanks,
> chris
>

[Database Administrator]

You were absolutly right Aaron........that was it. Thanks for the help. And
im going to do the same as you in the customization of the icons.

"Aaron Bertrand [SQL Server MVP]" wrote:

> Are you hitting F5 or the "!" icon (execute button)? Or are you hitting the
> debug button (looks like a green "play" icon)? One of the first things I do
> when I install a new copy of 2008 SSMS is customize the toolbar and get that
> debug button out of there. It reminds me of Query Analyzer's "execute"
> button and to be honest if I ever have a need for debugging in SSMS I will
> be able to handle going through a menu to get to it.
>
> A
>
>
>
>
>
> On 10/27/08 1:24 PM, in article
> BD15779E-4E96-4D9B-B884-7DB711B43137@microsoft.com, "TJ"
> wrote:
>
> > Hello, and thanks for your assistance in advance. I am running Sql Server
> > 2008 Express with advanced services. Every time I run a sql script, it just
> > hangs.....the action line just shows "Debugging Query". There are no other
> > errors or problems. Any query does this. I have reinstalled twice and same
> > thing.
> >
> > Thanks,
> > chris
> >
>
>