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

Please excuse me. I inadvertently sent this to the wrong group. I must have
clicked off Tools, which is where I meant it to go.

"Chuck Hawkins" <charles.hawkins@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23PVMDRp%23FHA.2520@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
>


.