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

There is a product suggestion logged for this already. I suggest going
there and voting for it and maybe it will get some attention.

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=e242a31c-d3d1-45e7-a25e-9b5323294581

and

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=8098e484-1019-4331-aaba-1d11828d887a




"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
>
>
>


.