Re: Management Studio: DB Context: Script Opens a new connection - How do I get script to reuse the connection from a previous script?

I started a thread on this same issue on 11/12/2005 - titled 'Management
Studio Automation.' You can check that out for some ideas on how to deal
with this.

It is the one deal-breaker that is keeping me from moving to Management
Studio. There were a bunch of workarounds posted, but all of them were just
that - work arounds.




"Chuck Hawkins" <charles.hawkins@xxxxxxxxxxxxxxxxxx> wrote in message
news:O$SKFWp%23FHA.1256@xxxxxxxxxxxxxxxxxxxxxxx
>I just partially discovered how to work around something that was driving
>me
> crazy.
>
> When I was opening up a script to apply to a database, the Query Windows
> was
> always opening a new connection to the Master Database. I want Query
> Anazlyzer-like functionality where the script is opened in the same
> connection to the same database, causing me not to have 10 succesive
> windows
> open when I open and quickly run 10 successive scripts. Instead what was
> happening was each script opens a new connection to the master DB.
>
> I discovered that if I change the database one time in the Connection
> Properties tab of the Connect to Database Engine window, exposed after
> clicking the Options>> button successive windows will at least open up in
> the same database context and I don't have to keep switching from Master.
>
> Now, how do I get Management Studio to re-use the same connection for
> succesive scripts?
>
> Thanks,
>
> Chuck Hawkins
>
>
>


.