SQL 2005 query analyzer

1 Nov 2005 3:32 PM

DanW

I used the SQL 2005 beta for a while, but this was enough for me to
uninstall it. I have now installed the released version of SQL 2005.

I routinely opened query analyzer, opened 1 window and selected the
database, then drag-and-dropped multiple *.sp files into the window in order
to execute them. Now, SQL 2005 insists on me reconnecting and logging in
with every single file I drop! The same thing happens when opening a file
with the file open command.

Is there a way around this annoyance or a way to reinstall the old query
analyzer?

Dan

9 Nov 2005 7:17 AM

William Stacey [MVP]

Create a project in SSMS. Then add all your scripts to the project. Then
your scripts will be associated with a connection and you don't have to
drag-drop, just open and exec.

--
William Stacey [MVP]

Show quote

"DanW" <ac_zr5002002eatspam@yahoo.com> wrote in message
news:uwBOzlv3FHA.696@TK2MSFTNGP09.phx.gbl...
>I used the SQL 2005 beta for a while, but this was enough for me to
>uninstall it. I have now installed the released version of SQL 2005.
>
> I routinely opened query analyzer, opened 1 window and selected the
> database, then drag-and-dropped multiple *.sp files into the window in
> order to execute them. Now, SQL 2005 insists on me reconnecting and
> logging in with every single file I drop! The same thing happens when
> opening a file with the file open command.
>
> Is there a way around this annoyance or a way to reinstall the old query
> analyzer?
>
> Dan
>